How to update salary of employees department wise?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / shaalimaar

6 Answers
14933 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to update salary of employees department wise?..

Answer / k v koteswara rao

UPDATE employees SET salary=DECODE(department_id,10,salary+1000,20,salary+2000,30, salary+3000,salary);

Is This Answer Correct ?

18 Yes

0 No

How to update salary of employees department wise?..

Answer / 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

How to update salary of employees department wise?..

Answer / 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

How to update salary of employees department wise?..

Answer / prativa mishra

update employees
set salary=salary+1000
where department_id=&department_id

Is This Answer Correct ?

4 Yes

3 No

How to update salary of employees department wise?..

Answer / 8008064637

begin
updata emp set sal=sal+1000 where deptno in(10,20,30,40);
end;

Is This Answer Correct ?

4 Yes

4 No

How to update salary of employees department wise?..

Answer / meher.shareen

begin
update emp set sal=sal+1000
where deptno=10;
update emp set sal=sal+2000
where deptno=20;
update emp set sal=sal+3000
where deptno=30;
update emp set sal=sal+4000
where deptno=40;
end;

Is This Answer Correct ?

1 Yes

5 No

Post New Answer