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