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
执行结果:
分页查询...
select top 10 * from ComprehensiveShow where id not in(select top 40 id from ComprehensiveShow order by id)
意思是查询前40条数据，在查询不在前40条数据中的前10条数据
//select top 10 * from Comprehe...
