Women in Technology

Hear us Roar

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.

Showing messages 1 through 2 of 2.

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