Fork me on GitHub

分页查询

Student表如下图:

分页查询方式一:

1 select top 3 * from Student
2 where StudentId not in
3 (
4 select top 3 StudentId from Student
5 order by StudentId
6 )
7 order by StudentId

执行结果:

分页查询方式二:

1 select * from
2 (
3 select *, row_number() over(order by StudentId)as id from Student
4 )as tem 
5 where id between 2 and 6

执行结果:

 

posted @ 2017-03-14 10:12  L波涛  阅读(124)  评论(0)  编辑  收藏  举报