【SQL】分頁之Row_Number函式用法

在最前面插入一欄自動編號
select Row_Number() over (order by id) as RowNum,id,firstName,lastName from dbo.USERS

分頁(Paging)寫法
假設取第11筆~第20筆資料

select *
from (select row_number() over (order by id) as RowNum,id,firstName,lastName from dbo.USERS) as NewTable
where RowNum >=11 and RowNum<=20