一個使用ROW_NUMBER()分頁的範例

因為老是會忘記，所以記錄一個範本好了(ps SQL 2005以上版本才可以用ROW_NUMBER)
SELECT  *
FROM (
SELECT  ROW_NUMBER() OVER (ORDER BY id) AS rid, * FROM t1 where name != '1'
) AS NewTable
WHERE rid >= 1 AND rid <= 5