Oracle交集、并集、差集

并集：

union ：相同数据会进行去重

select 'aa' name from dual
union
select 'aa' name from dual 
union
select 'bb' name from dual 
union
select 'bb' name from dual

union all：相同数据不会进行去重

select 'aa' name from dual
union all
select 'aa' name from dual 
union all
select 'bb' name from dual 
union all
select 'bb' name from dual

 

交集：

 

select name from tmp_1 
intersect
select name from tmp_2

 

 差集：

返回的数据是：tmp_1表数据 减去 tmp_1和tmp_2 交集的数据

select name from tmp_1 
minus
select name from tmp_2

select name from tmp_2 
minus
select name from tmp_1