Question

Consider a scenario where the company plans to give a salary raise to employees with a performance rating of 4 or 5. Write an Oracle SQL query to update eligible employees' salaries by 8%.

Answer 1

UPDATE employees

SET salary = salary * 1.08

WHERE rating IN (4, 5);