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
浙公網安備 33010602011771號