差集:
select * from ancl_order
minusselect * from ancl_order where status = 'PAYED'
交集:
select * from ancl_order
intersect
select * from ancl_order where status = 'PAYED'
并集:
union all 直接合并不操作
union 对结果进行排序,并去重
(两种合并方式都需要 查询结果字段数量形同,类型相同)
select * from ancl_order
union
select * from ancl_order where status = 'PAYED'
或
select * from ancl_order
union all
select * from ancl_order where status = 'PAYED'