Pergunta de entrevista da empresa ec2 Software Solutions

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.

Resposta da entrevista

Sigiloso

22 de abr. de 2016

UPDATE @Employees SET Salary = Salary + 0.1*Salary WHERE Salary < 50000