常见三种 SQLserver 分页

 

1.top 嵌套 （1~10条数据）

select top 10 * from Target_List where id not in (select top 0 id from Target_List order by id) order by id

 

2. row_number(通过ROW_NUMBER()生成序号列,根据序号列取需要数据) 

select * from ( SELECT *,row_number()over(order by id) as rowindex from Target_List)a  where a.rowindex >= 1 and a.rowindex <=20

3.offset x rows=>跳过前1行 fetch next y rows=>取之后的10行

SELECT * FROM Target_List ORDER BY id OFFSET 1 ROWS FETCH NEXT 10 ROWS ONLY