Update Employee Salary

—

To update the salary of employees in department 1 by a 10% raise:

UPDATE employees
SET salary = salary * 1.10
WHERE department_id = 1;

Comments