set statistics time on;
– 分页查询(通用型)
select * from student
order by sno
offset ((@pageIndex-1)*@pageSize) rows
fetch next @pageSize rows only;
– 分页查询第2页,每页有10条记录
select * from student
order by sno
offset 10 rows
fetch next 10 rows only ;
offset A rows ,将前A条记录舍去,fetch next B rows only ,向后在读取B条数据。