分页查询

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

执行结果:

欢迎转载，让更多的人看到吧，记得注明出处哦！

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/liutao1122/p/6547062.html