当前位置：Gxlcms >
数据库问题 >
【Oracle学习笔记-5--】集合操作之union，intersect和minus操作
【Oracle学习笔记-5--】集合操作之union，intersect和minus操作
时间：2021-07-01 10:21:17
帮助过：4人阅读
select e.employee_id,e.last_name from hr.employees ewhere e.last_name like ‘C%‘unionselect e.employee_id,e.last_name from hr.employees ewhere e.last_name like ‘S%‘;--等价于select e.employee_id,e.last_name from hr.employees ewhere e.last_name like ‘C%‘or e.last_name like ‘S%‘;
-- intersect交集操作select e.employee_id,e.last_name from hr.employees ewhere e.last_name like ‘C%‘or e.last_name like ‘S%‘intersectselect e.employee_id,e.last_name from hr.employees ewhere e.last_name like ‘S%‘or e.last_name like ‘T%‘;--等价于select e.employee_id,e.last_name from hr.employees ewhere e.last_name like ‘S%‘;
--minus差操作select e.employee_id,e.last_name from hr.employees ewhere e.last_name like ‘C%‘or e.last_name like ‘S%‘minusselect e.employee_id,e.last_name from hr.employees ewhere e.last_name like ‘S%‘or e.last_name like ‘T%‘;--等价于select e.employee_id,e.last_name from hr.employees ewhere e.last_name like ‘C%‘;
博客：http://www.cnblogs.com/ssslinppp http://blog.sina.com.cn/spstudy 淘宝-代做毕设：http://shop110473970.taobao.com/?spm=a230r.7195193.1997079397.42.AvYpGW http://shop125186102.taobao.com/?spm=a1z10.1-c.0.0.SsuajD来自为知笔记(Wiz)
【Oracle学习笔记-5--】集合操作之union，intersect和minus操作
标签：
