範例是,每頁10筆,現在取得第三頁資料,關鍵在於 row_number() OVER (ORDER BY rowautoid)
這個只有mssql2005之後才有的
select * from
( select row_number() OVER (ORDER BY rowautoid) AS RankNumber,* from
( select * FROM Person as p where 1=1 ) as pager
) as ppg
WHERE RankNumber between (10*(3-1)+1) and (10*3)