34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT * FROM CUS_CONTACT WHERE IS_VALID='0' ORDER BY CONTACT_ID DESC
--这句话查询到的是25条记录
SELECT CONTACT_ID FROM CUS_CONTACT
--这句话查询到的记录是15000+
SELECT CONTACT_ID FROM CUS_CONTACT WHERE NOT EXISTS(SELECT CONTACT_ID FROM CUS_CONTACT WHERE IS_VALID='0')
--这句话查询不到任何记录
SELECT CONTACT_ID FROM CUS_CONTACT WHERE CONTACT_ID NOT IN (SELECT CONTACT_ID FROM CUS_CONTACT WHERE IS_VALID='0')
--用not in 就可以查询成功
SELECT CONTACT_ID FROM CUS_CONTACT WHERE NOT EXISTS(SELECT CONTACT_ID FROM CUS_CONTACT WHERE IS_VALID='0' and CONTACT_ID=t.CONTACT_ID)
--TRY
SELECT CONTACT_ID
FROM CUS_CONTACT a
WHERE
IS_VALID =0 AND
NOT EXISTS(SELECT CONTACT_ID FROM CUS_CONTACT WHERE IS_VALID=a.IS_VALID)
SELECT CONTACT_ID FROM CUS_CONTACT t WHERE NOT EXISTS(SELECT CONTACT_ID FROM CUS_CONTACT WHERE IS_VALID='0' and CONTACT_ID=t.CONTACT_ID)
--这句话查询不到任何记录
SELECT CONTACT_ID FROM CUS_CONTACT t WHERE NOT EXISTS(SELECT 1 FROM CUS_CONTACT WHERE IS_VALID='0' and CONTACT_ID =t.CONTACT_ID )