我有以下查询:
delete from departments
where department_id = (select department_id
from employees
where salary > 100000);
该查询当然返回多行,有人知道如何在不执行功能或类似操作的情况下仅通过一个查询删除所有部门?
或者加入他们
DELETE d
FROM departments d
INNER JOIN employees e ON d.department_id = e.department_id
WHERE e.salary > 100000;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句