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 example of procedure?

878

Can we rollback delete command?

936

Why do we need unique key in a table?

886

How do I get sql certification?

926

how to load data files into tables with 'mysqlimport'? : Sql dba

1035

Why use subqueries instead of joins?

1034

What is use of trigger?

875

Why is nosql good?

978

How do I use google cloud in sql?

1035

how to use 'mysql' to run sql statements? : Sql dba

986

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1128

Can we use join in subquery?

1023

Why do we use procedures?

914

What is raid? How does it help storage of databases?

1035

What is a recursive join sql?

1027