SELECT DEPTNO FROM DEPT
MINUS
SELECT EMPNO FROM EMP
使用minus字段必须一致
SELECT A.* FROM DEPT A
LEFT JOIN EMP B
ON A.DEPTNO = B.DEPTNO
WHERE B.DEPTNO IS NULL
SELECT DEPTNO FROM DEPT
MINUS
SELECT EMPNO FROM EMP
使用minus字段必须一致
SELECT A.* FROM DEPT A
LEFT JOIN EMP B
ON A.DEPTNO = B.DEPTNO
WHERE B.DEPTNO IS NULL