Loading

Help with SQL table column having null

vivek upadhyay

12y1.8k

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhay Shanker12y ago
Update emp set n_salary=o_salary
Khan Abrar Ahmed12y ago
Hi,

update emp set n_salary=5000 where name='A'
update emp set o_salary=600 where name='b'
Bharath Reddy12y ago
update emp set o_salary=5000,n_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 Gupta12y ago
UPDATE table_name
SET column1=value1,column2=value2,...