sql 分頁
OFFSET 20 ROWS
FETCH NEXT 10 ROWS ONLY;
MS-SQL 分頁 (SQL Paging)
https://blog.xuite.net/dlnk/work/51786477-MS-SQL+%E5%88%86%E9%A0%81+%28SQL+Paging%29
ROW_NUMBER() Function
https://dotblogs.com.tw/jimmyyu/2009/11/09/11499
sql 分頁
OFFSET 20 ROWS
FETCH NEXT 10 ROWS ONLY;
MS-SQL 分頁 (SQL Paging)
https://blog.xuite.net/dlnk/work/51786477-MS-SQL+%E5%88%86%E9%A0%81+%28SQL+Paging%29
ROW_NUMBER() Function
https://dotblogs.com.tw/jimmyyu/2009/11/09/11499