SQL TOP 分页 

1 SELECT TOP 每页大小 * 
2 FROM Test 
3 WHERE 
4     ID NOT IN           
5         (SELECT TOP 每页大小*页数 id          
6         FROM Test          
7         ORDER BY id)
8 ORDER BY ID

 

例子：

1 SELECT TOP 10 * 
2 FROM Test 
3 WHERE 
4     ID NOT IN           
5         (SELECT TOP 20 id          
6         FROM Test          
7         ORDER BY id)
8 ORDER BY ID

 

posted @ 2016-09-26 17:31  我在赫尔辛基火车站  阅读(168)  评论(0)  编辑  收藏  举报