Interested to Buy Any Domain ? << Click Here >> for more details...
How to update salary of employees department wise?
- 6 Answers
- 14941 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is row_number () in sql?
What is clustered and nonclustered index in sql?
What are all the ddl commands?
what is a control file ? : Sql dba
what is the difference between join and union? : Sql dba
What does joining a thread mean?
Can we connect to postgresql using sql developer?
Difference between table function and pipelined function?
How can use stored procedures in sql?
What does <> sql mean?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Can a trigger call a stored procedure?
What are the parts of a basic sql query?
What are the types of join in sql?
How do I find duplicates in sql?
