sql查询in包含null的情况下,查询结果为空。
解决方案:1.用EXISTS 替换
SELECT d.*
FROM dept d
where NOT EXISTS (
SELECT NULL
FROM emp e
WHERE e.DEPTNO=d.DEPTNO
2.查询子句去除掉null
SELECT * FROM dept d
WHERE d.DEPTNO NOT in (SELECT DEPTNO FROM new_dept WHERE DEPTNO is NOT NULL);