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 start sql from command line?

996

How to download oracle sql developer?

1082

How do you modify a table in sql?

1103

What is form and report?

959

What is rowtype?

994

What does where 1 1 mean in sql?

1019

What is the difference between row level and statement level trigger?

1002

How to raise user-defined exception with custom sqlerrm ?

1114

What is recursive stored procedure?

1081

What is cursor in pl sql?

1093

What is the difference between numeric and autonumber?

980

How do you explain an index?

1264

How to call shell script from pl sql procedure?

1244

What is synchronized subquery?

1138

what is the difference between a local and a global temporary table? : Sql dba

1045