云数据仓库ADB这个能解读一下吗?
SELECT * FROM (
SELECT '2023-10-13' AS dt, '1111' AS a
UNION ALL
SELECT '2023-10-13' AS dt, '1112' AS a
) AS A
WHERE (
SELECT COUNT(1) FROM (
SELECT '2023-10-13' AS dt, '1112' AS b
) AS B
WHERE B.dt='2023-10-13' AND B.b=A.a
)=0
AND A.dt='2023-10-13';