--union并操作
select e.employee_id,e.last_name from hr.employees e
where e.last_name like 'C%'
union
select e.employee_id,e.last_name from hr.employees e
where e.last_name like 'S%';
--等价于
select e.employee_id,e.last_name from hr.employees e
where e.last_name like 'C%'or e.last_name like 'S%';
![](https://i-blog.csdnimg.cn/blog_migrate/16a3c15a62d768198727b2158ba49a77.png)
-- intersect交集操作
select e.employee_id,e.last_name from hr.employees e
where e.last_name like 'C%'or e.last_name like 'S%'
intersect
select e.employee_id,e.last_name from hr.employees e
where e.last_name like 'S%'or e.last_name like 'T%';
--等价于
select e.employee_id,e.last_name from hr.employees e
where e.last_name like 'S%';
![](https://i-blog.csdnimg.cn/blog_migrate/ec362cb82f2e2e4e0700035b04fb422c.png)
--minus差操作
select e.employee_id,e.last_name from hr.employees e
where e.last_name like 'C%'or e.last_name like 'S%'
minus
select e.employee_id,e.last_name from hr.employees e
where e.last_name like 'S%'or e.last_name like 'T%';
--等价于
select e.employee_id,e.last_name from hr.employees e
where e.last_name like 'C%';
![](https://i-blog.csdnimg.cn/blog_migrate/b69117aeec3151d11ed067216b03625b.png)
博客:
淘宝-代做毕设: