sql server分页

-- 分页查询（通用型） ：利用row_number关键字

select top pageSize * from (select row_number() over(order by sno asc) as rownumber,* from student) temp_row where rownumber>((pageIndex-1)*pageSize);