sql server的简单分页
程序员文章站
2023-02-06 10:15:07
--显示前条数据 select top(4) * from students; --pageSize:每页显示的条数 --pageNow:当前页 select top(pageSize) * from students where sno not in (select top(pageSize*(p ......
--显示前条数据
select top(4) * from students;
--pagesize:每页显示的条数
--pagenow:当前页
select top(pagesize) * from students where sno not in (select top(pagesize*(pagenow-1)) sno from students);
--带条件的分页
select top (pagesize) * from students where sno not in (select top(pagesize*(pagenow-1)) sno from students where ssex='男') and ssex='男';
与oracle的分页有些大同小异,就不一一介绍了oracle分页连接