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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!