sqlserver分页的三种实现(非存储过程)

yx_new_stu表名

gkksh为主键

每页条数10

当前取第二页

 

select top 10 * from yx_new_stu where GKKSH not in (select top 10 GKKSH from yx_new_stu order by GKKSH asc) order by GKKSH asc;

 

select * from (select top 10 * from (select top 20 * from yx_new_stu order by GKKSH asc) a order by a.gkksh desc) b order by gkksh asc;

 

select top 10 * from yx_new_stu where gkksh > (select max(t.GKKSH) from (select top 10 * from yx_new_stu order by gkksh asc) t) order by gkksh asc;

 

 

 

 

总页数计算

pgNum=(totalCount+pgSize-1)/pgSize