| 内容 | 根据题意理解:
 本质就是写分页查询:
 每页条数:10条;
 当前页码:4页;
 代码如下:
 //第一种:
 select * from
 (select ROW_NUMBER() over(order by Id asc) as num,* from UserInfo)as u
 where u.num
 between
 10*(4-1)+1
 and
 10*4
 //第二种:
 select top 10 * from UserInfo
 where Id not in
 (select top (10*3) id from UserInfo order by Id)
 order by Id
 |