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 do I write a cron which will run a sql query and mail the results to agroup?

1031

what are the advantages a stored procedure? : Sql dba

1018

What is sql data?

1034

How is indexing done in search engines?

1023

what does it mean to have quoted_identifier on? : Sql dba

1181

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1076

How do I start sql profiler?

1048

How to avoid using cursors?

1175

What is asqueryable?

1035

What are the different parts of a package?

1152

explain advantages of innodb over myisam. : Sql dba

1175

what is row? : Sql dba

1277

What are some predefined exceptions in pl/sql?

1224

Explain the the delete statements in sql?

1116

How to execute a stored procedure?

1156