[MS SQL] [T-SQL] 分頁處理：OFFSET 和 FETCH 子句 (SQL Server 2012)

Just a note to myself...

-- Using OFFSET/ FETCH (This performance was the best.)

SELECT * FROM Vocab

ORDER BY ID

OFFSET 0 ROWS

FETCH NEXT 20 ROWS ONLY;

-- Using Row_Number()

SELECT * 

FROM (

     SELECT row_number() OVER (ORDER BY ID) AS RowNum,ID,word

     FROM dbo.Vocab) AS NewTable

WHERE RowNum >=10 and RowNum<=20;

Reference:

http://sharedderrick.blogspot.tw/2012/06/t-sql-offset-fetch.html

http://blog.xuite.net/xiaolian/blog/51944029-%5BSQL%5D+分頁之Row_Number函式用法