UPDATE EMP SET SAL=DECODE ( DEPTNO, 10, SAL+SAL*0.1, 20, SAL

How to update salary of employees department wise?

Question Posted / manoranjan sethy

Answer Posted / manoranjan sethy

UPDATE EMP
SET SAL=DECODE (
DEPTNO,
10, SAL+SAL*0.1,
20, SAL+SAL*0.2,
30, SAL+SAL*0.3,
40, SAL+SAL*0.4,
'NA'
)
/

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1136

What is a parameter query?

1143

What are the types of optimization?

1008

Is it important to partition hard disk?

1069

What is ttitle and btitle?

1115

Can you load data into multiple tables at once? : aql loader

1120

which tcp/ip port does sql server run on? : Sql dba

1084

Does a user_objects view have an entry for a trigger?

1051

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1164

what is timestamp in mysql? : Sql dba

1133

What is the command used to fetch first 5 characters of the string?

1467

Define overloaded procedure?

1132

what is the use of friend function? : Sql dba

1062

What is scalar function?

1096

What is cross join example?

1067