---row_number基本查询
select *
from ( select Id ,
PassWord ,
row_number() over ( order by Id desc ) RowNo--RowNo 从1开始
from dbo.T_StudentBase
) as t
where t.RowNo between 1 and 10;
-- 分页运用 每页10行 查询第2页
select *
from ( select Id ,
PassWord ,
row_number() over ( order by Id desc ) RowNo--RowNo 从1开始
from dbo.T_StudentBase
) as t
where t.RowNo between 10*(2-1)+1 and 2*10; --between 每页行数*(当前查询的页码-1)+1 and 每页行数*当前查询页码