主要利用到了左连接取交集的原理。
select * from (SELECT TOP 20 A.*,B.ID AS IDS FROM SURVEYINFO A LEFT JOIN (SELECT TOP 10 ID FROM SURVEYINFO) B ON A.ID=B.ID ) t
WHERE IDS is null
主要利用到了左连接取交集的原理。
select * from (SELECT TOP 20 A.*,B.ID AS IDS FROM SURVEYINFO A LEFT JOIN (SELECT TOP 10 ID FROM SURVEYINFO) B ON A.ID=B.ID ) t
WHERE IDS is null
转载于:https://www.cnblogs.com/huanghai223/archive/2012/01/19/2327311.html