ec2 Software Solutions interview question
Given a table Employees (UID, LastName, FirstName, Salary), write a statement that will modify table by giving 10% increase to all employees whose salaries are less than 50k.
Interview Answer
Anonymous
Apr 22, 2016
UPDATE @Employees SET Salary = Salary + 0.1*Salary WHERE Salary < 50000