I have a Query In MySQL
Give all managers of First Bank Corporation a 10 percent salary raise unless the salary become greater than $100000; in such cases, give only a 3 percent raise.
set Salary= salary + salary * 0.10
where company_name = 'First Bank Corporation' AND
emp_name IN (Select manager_name from Manages) AND
salary > 100000;
UPDATE ... SET salary = CASE WHEN salary * 1.10 > 100000 THEN salary * 1.03 ELSE salary * 1.10 END WHERE ...
UPDATE ... SET salary = salary * CASE WHEN salary * 1.10 > 100000 THEN 1.03 ELSE 1.10 END WHERE ...