Interested to Buy Any Domain ? << Click Here >> for more details...
How to update salary of employees department wise?
- 6 Answers
- 15219 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 auto increment? : Sql dba
what are the authentication modes in sql server? How can it be changed? : Sql dba
Difference between truncate, delete and drop commands?
What is the difference between rename and alias?
What is the process of debugging?
What is the difference between syntax error and runtime error?
What are crud methods?
what are the join types in tsql? : Transact sql
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What does pragma mean?
Is like operator in sql case sensitive?
What is oracle and pl sql?
Is natural join and inner join same?
Can %notfound return null after a fetch?
What is sql prepared statement?
