注意审题:1、获奖员工——员工id 2、当前
update salaries set salary = salary * 1.1 where to_date = '9999-01-01' and emp_no in (select emp_no from emp_bonus);
注意审题:1、获奖员工——员工id 2、当前
update salaries set salary = salary * 1.1 where to_date = '9999-01-01' and emp_no in (select emp_no from emp_bonus);