34,593
社区成员
发帖
与我相关
我的任务
分享
;WITH D1(phone)AS(
select phone FROM 表 WHERE 时间 BETWEEN XXX AND XXX
),D2(phone)AS(
select phone FROM 表 WHERE 时间 BETWEEN XXX AND XXX
)
SELECT D1.* FROM D1 WHERE NOT EXISTS(SELECT * FROM D2 WHERE D2.phone = D1.phone)
SELECT * FROM D1 WHERE NOT EXISTS(SELECT * FROM D2 WHERE D2.phone = D1.phone)
SELECT * FROM D1 WHERE NOT EXISTS(SELECT * FROM D2 WHERE D2,phone = D1.phone)