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

what is the difference between sql and t-sql? : Transact sql

1089

Why do we need cursors in pl sql?

1088

What are different types of queries in sql?

1121

What is the primary use of normalization?

1007

Does sql*plus also have a pl/sql engine?

1082

Explain isolation levels. : Transact sql

1074

Can we rollback truncate?

1002

Explain the types of joins in sql?

1035

Why do we need cursor in pl sql?

1138

What are the benefits of triggers?

1174

how can we repair a mysql table? : Sql dba

983

What are the types of join in sql?

1104

How many row comparison operators are used while working with a subquery?

1033

What does dml mean?

993

What does joining a thread mean?

1023