MySQL 集合元素运算实例
(1)方法一:利用NOT IN搜索
SELECT emp_no FROM employees WHERE emp_no NOT IN (SELECT emp_no FROM dept_manager)
(2)方法二:构造连表;利用子查询
select a.e1 as emp_no
from (select e.emp_no as e1,d.emp_no as d1 from employees e left join dept_manager d
on e.emp_no=d.emp_no)a where a.d1 is null
(3)方法三:利用集合计算求解
SELECT employees.emp_no
FROM employees
EXCEPT
SELECT dept_manager.emp_no
FROM dept_manager
MySQL集合运算符
EXCEPT 集合差运算
UNION 集合并运算
INTERSECT 集合交运算