Article:
  SQL Subqueries
Subject:   Help! Need to increase salary by 5%
Date:   2005-03-22 07:24:39
From:   cmrosiek
Help,


I am taking a sql class in which we are using Access to program. I have a table with employees and salaries in which I need to increase the salary by 5%. Do I need a subquery and how do I do it?


Help, thanks.

Main Topics Oldest First

Showing messages 1 through 1 of 1.

  • Help! Need to increase salary by 5%
    2005-08-03 00:35:59  bhawana [View]

    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)