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

What is multiple partition?

949

What is a record in pl/sql?

1123

What is not null in sql?

1032

What is a full join?

956

Why triggers are used?

968

How do I partition a table in sql?

1100

what is the use of set statement in tsql? : Transact sql

993

What is the trigger in sql?

929

How do I find duplicates in a single column in sql?

996

how would concatenate strings in mysql? : Sql dba

1066

How long will it take to learn pl sql?

920

How do you copy a table in sql?

1047

What is difference between hql and sql?

1052

Is time a data type in sql?

887

Is sqlite good enough for production?

981