update emp set sal = case Deptno when 10 then 1000

How to update salary of employees department wise?

Question Posted / ajit nayak

Answer Posted / ajit nayak

update emp
set sal = case Deptno when 10 then 1000
when 20 then 2000
when 30 then 3000
else 0
end;

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I remove all records from a table?

1117

How to add a column ‘salary’ to a table employee_details?

1052

How does a trigger work?

1145

what is the difference between sql and t-sql? : Transact sql

1136

Can a foreign key be a duplicate?

963

What is pl/sql table? Why is it used?

1092

What is using in sql?

1141

What is bulk collect in pl sql?

1158

what is a field in a database ? : Sql dba

1099

Explain the significance of the & and && operators in pl sql.

1048

What does <> sql mean?

1167

What is the difference between in and between in sql?

1109

What is write ahead logging in sql server?

1101

What is sqlexception in java?

1037

Explain the difference between drop and truncate commands in sql?

1111