oracle的not exist, not in, left join 的写法，不在xx之内(原创)
| 阿里云国内75折 回扣 微信号：monov8 |
| 阿里云国际，腾讯云国际，低至75折。AWS 93折 免费开户实名账号 代冲值 优惠多多 微信号：monov8 飞机：@monov6 |
SELECT T2.DEPTNO
FROM DEPT2 T2
WHERE NOT EXISTS
(SELECT 1 FROM DEPT WHERE DEPT.DEPTNO = T2.DEPTNO)
SELECT T2.DEPTNO
FROM DEPT2 T2
WHERE T2.DEPTNO NOT IN
(SELECT T1.DEPTNO FROM DEPT T1);
SELECT *
FROM (SELECT T1.DEPTNO T12, T2.DEPTNO T22
FROM DEPT2 T2
LEFT JOIN DEPT T1 ON T1.DEPTNO = T2.DEPTNO)
WHERE T12 IS NULL