查询A表id,在 1、 2、 3、 4 中不存在的数据并返回对应的id。
1、查询SQL
select id from A where id in ('1','2','3','4');
2、返回3、 4
SELECT
B.id
FROM
(
SELECT "1" AS id FROM DUAL
UNION
SELECT "2" AS id FROM DUAL
UNION
SELECT "3" AS id FROM DUAL
UNION
SELECT "4" AS id FROM DUAL
) B
LEFT JOIN A ON A.id = B.id
WHERE
A.id IS NULL;