How to update multiple columns with single select query
I want to update few columns of a row with few columns of another row. Is there any way to do it with update with single query.
e.g.
tabale : Empl
empno salary level department
I want to write an update statement that updates salary and level of an employee whose empno is x, with salary and level of employee with empno y.