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 the repeatable read and serializable isolation levels? : Transact sql

1013

What is substitution variable in pl sql?

978

What is the basic structure of an sql?

1031

What is sqlerrm?

882

Explain locks? : Transact sql

950

What is sql*loader and what is it used for?

1044

What are the types of triggers in sql?

1015

What are the two types of exceptions in pl/sql?

964

How do you respond to dementia behavior?

924

what is a unique key ? : Sql dba

1024

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1005

Is big data nosql?

885

Write a sql select query that only returns each name only once from a table?

958

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

1098

How many sectors are in a partition?

1031