新分頁語法 OFFSET + FETCH

SQL 新的分頁語法  OFFSET 和 FETCH，效能比先前的 ROW_NUMBER() 函數速度快上許多。
ex:

SELECT *

FROM

(

SELECT ID, ROW_NUMBER() OVER (ORDER BY ID)  AS RowID

FROM Table_2

) A

WHERE RowID BETWEEN 3*10 AND (3+1)*10-1

;

SELECT *

FROM

(

SELECT ID, ROW_NUMBER() OVER (ORDER BY ID)  AS RowID

FROM Table_2

) A

ORDER BY RowID

OFFSET 3*10-1 Rows 

FETCH NEXT 10 Rows ONLY

;