Interested to Buy Any Domain ? << Click Here >> for more details...
How to update salary of employees department wise?
- 6 Answers
- 14942 Views
- I also Faced
- E-Mail Answers
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
What is sql dialect?
How to use boolean type in select statement?
What are the various levels of constraints?
How do you write a complex sql query?
what are the performance and scalability characteristics of mysql? : Sql dba
how many values can the set function of mysql take? : Sql dba
how to rename an existing table in mysql? : Sql dba
What is the purpose of design view?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is bitemporal narrowing?
Can we use pl sql in mysql?
Explain lock escalation? : Transact sql
what are date and time functions in mysql? : Sql dba
Is sql better than excel?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
