摘要：
主要利用到了左连接取交集的原理。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 阅读全文
|