How to update salary of employees department wise?
Answer Posted / 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 View All Answers
Can we use distinct and group by together?
Why do we need pl sql?
what is a foreign key ? : Sql dba
What is self-join and what is the requirement of self-join?
Enlist the characteristics of pl/sql?
what are ddl statements in mysql? : Sql dba
What is scalar and vector?
What are different types of indexes?
what are the types of join and explain each? : Sql dba
What is acid property in a database?
How do I order columns in sql?
What is sqlca in powerbuilder?
What are all the different types of indexes?
What is difference between db2 and sql?
What are the different types of sql commands?