How to update salary of employees department wise?
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 trigger price?
Where is sql database stored?
what is isam? : Sql dba
Can we create view in stored procedure?
How do you optimize a stored procedure in sql?
How is use pl and sql?
how to shut down the server with 'mysqladmin'? : Sql dba
Explain the insert into statements in sql?
how can you create an empty table from an existing table? : Sql dba
where are cookies actually stored on the hard disk? : Sql dba
What is sqlexception in java?
Can you join views in sql?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What are the different types of dbmss?
Can you inner join the same table?