【分页查询】
先看SQL学习笔记14子查询,在看分页查询
--每页三条 查第五页的
select * from
(select 编号=ROW_NUMBER() over(order by tsname desc),* from student)as newStu
where newStu.编号 between (5-1)*3+1 and 3*5
--每页9条数据 查询13页的
select * from
(select 编号=ROW_NUMBER() over(order by id),* from MyOrders) as Orders
where 编号 between (13-1)*9+1 and 13*9
--第一种:分页的方法sql
--一页 :3条 第四页
-- 越过多少条(2-1)*3 取多少条 3
--select top 3 * from UserInfo where UserId not in
--(
-- select top ((4-1)*3) UserId from UserInfo order by UserId
--) --越过的数据的id的集合
--order by UserId
--第二种:分页sql 一页3条, 取第 4页
--select * from (
-- select *,ROW_NUMBER() over(order by userid) as num from UserInfo
--) as T
--where T.num between ((4-1)*3+1) and (4*3)