update employees set salary=salary+1000 where department

How to update salary of employees department wise?

Question Posted / prativa mishra

Answer Posted / prativa mishra

update employees
set salary=salary+1000
where department_id=&department_id

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

how to get a list of indexes of an existing table? : Sql dba

972

What is the difference between function, procedure and package in pl/sql?

1276

How you improve the performance of sql*loader? : aql loader

1022

Is delete faster than truncate?

1016

Why is stored procedure faster than query?

972

What is data type in sql?

976

Can one improve the performance of sql*loader? : aql loader

1058

What is the difference between inner join and outer join?

1005

how to delete an existing column in a table? : Sql dba

1021

how to decrement dates by 1 in mysql? : Sql dba

1031

What is trigger and stored procedure in sql?

1050

What is trigger in pl sql?

1011

Write an sql query to select all records from the table?

1048

What are operators available in sql?

1058

How do I count rows in sql query?

1007