【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