笔记23 row_number over()分页存储过程

笔记23 row_number over()分页存储过程

--row_number over()分页存储过程
DECLARE @pageSize INT
DECLARE @pageindex INT
SELECT  @pageSize=5 ,@pageindex=2
;
with
id as(
     select
          row_id = row_number() over(order by RecordNo asc),
          RecordNo     -- 主键列名
     from dbo.SystemPara
)
select
     data.*
from dbo.SystemPara data
     inner join id
          on id.row_id  = data.RecordNo
where id.row_id >(@pageSize*(@pageindex-1))
     and id.row_id < (@pageSize*(@pageindex))