ACCESS高效分页SQL

主要利用到了左连接取交集的原理。

 

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