Help with SQL table column having null

Question

Suppose a emp table contain following field

name,o_salary,n_salary and n_salary is blank ,there values is:
A 5000
b 6000
c 7000
d 8000
now I want to update emp table with following data:-
name o_salary n_salary
A 5000 5000
b 600

Help me immediate

Abhay Shanker · Answer

Update emp set n_salary=o_salary

Khan Abrar Ahmed · Answer

Hi update emp set n_salary=5000 where name='A' update emp set o_salary=600 where name='b'

Bharath Reddy · Answer

update emp set o_salary=5000n_salary=5000 where name='A' update emp set o_salary=600 where name='b' If you dont want c and d rows then delete from emp where name in ('c''d')

Princy Gupta · Answer

UPDATE table_name SET column1 = value1  column2 = value2 ...