首页 > 代码库 > 分页查询

分页查询

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

执行结果:

技术分享

 

分页查询