SQL是在ME里写的,ME里必须写用户名+表名才可以查询,所以看起来比较冗余,各位自行处理一下吧。
UNION 并集+去重复 | |
UNION ALL 并集 | |
INTERSECT 交集 | IN |
MINUS 差集 | NOT IN |
SELECT DEPT.DEPTNO DEPTNO
FROM SCOTT.DEPT DEPT
UNION
SELECT EMP.DEPTNO
FROM SCOTT.EMP EMP
SELECT DEPT.DEPTNO DEPTNO
FROM SCOTT.DEPT DEPT
UNION ALL
SELECT EMP.DEPTNO
FROM SCOTT.EMP EMP
SELECT DEPT.DEPTNO DEPTNO
FROM SCOTT.DEPT DEPT
INTERSECT
SELECT EMP.DEPTNO
FROM SCOTT.EMP EMP
SELECT DEPT.DEPTNO DEPTNO
FROM SCOTT.DEPT DEPT
MINUS
SELECT EMP.DEPTNO
FROM SCOTT.EMP EMP