Article:  |
SQL Subqueries | |
| Subject: | Help! Need to increase salary by 5% | |
| Date: | 2005-08-03 00:35:59 | |
| From: | bhawana | |
|
Response to: Help! Need to increase salary by 5%
|
||
|
U do not need a subquery to achieve this.
|
||
Showing messages 1 through 1 of 1.
-
Help! Need to increase salary by 5%
2005-10-16 20:11:01 isabella57 [View]
It is very easy. Use the table and write REPLACE ALL SALARY WITH SALARIO*1.05 or UPDATE tablename set salary = salary * 1.05
