UPDATE salaries
SET salary = salary * 1.1
WHERE
emp_no IN ( SELECT emp_no FROM emp_bonus )
AND to_date = '9999-01-01'
牛客SQL练习-48-将所有获取奖金的员工当前的(salaries.to_date=‘9999-01-01‘)薪水增加10%
最新推荐文章于 2023-12-03 14:14:08 发布
UPDATE salaries
SET salary = salary * 1.1
WHERE
emp_no IN ( SELECT emp_no FROM emp_bonus )
AND to_date = '9999-01-01'