--查询排除 factory = 'A' 的结果集 select * from production where department = '1组' except select * from production where factory = 'A' --查询排除 factory = 'A' and department = '1组' 的结果集 select * from production where department = '1组' intersect select * from production where factory = 'A'