How to update salary of employees department wise?
- 6 Answers
- 14036 Views
- I also Faced
- E-Mail Answers
Answer Posted / prativa mishra
update employees
set salary=salary+1000
where department_id=&department_id
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is sql indexing?
Why are sql stored procedures used?
How can we find duplicate records in a table?
What are records give examples?
Is hadoop a nosql?
What is rtm stands for?
What is a heap in sql?
how to do backup entire database? : Transact sql
What is break?
how to include character strings in sql statements? : Sql dba
how can we find the number of rows in a table using mysql? : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How can we make an if statement within a select statement?
explain the options of myisamchk to improve the performance of a table. : Sql dba
What is the use of count (*) in sql?
