ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

advertisement

AddThis Social Bookmark Button
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.


This can also be achieved by using a simple
update query


Update tablename set salary = salary + (salary * .05)



1 to 1 of 1
1 to 1 of 1