Oracle的并集交减集

1并集UNION ALL UNION 

（1）UNION ALL 不去重
select ENAME,SAL,JOB from EMP where SAL > 2500
union all
select ENAME,SAL,JOB from EMP where JOB = 'MANAGER';
 （2 ）UNION 去重
select ENAME,SAL,JOB from EMP where SAL > 2500
union
select ENAME,SAL,JOB from EMP where JOB = 'MANAGER';

2交集INTERSECT

select ENAME,SAL,JOB from EMP where SAL > 2500
intersect
select ENAME,SAL,JOB from EMP where JOB = 'MANAGER'

3 差集 (减集)MINUS

select ENAME,SAL,JOB from EMP where SAL > 2500
minus
select ENAME,SAL,JOB from EMP where JOB = 'MANAGER'