SQLServer2005 利用 ROW_NUMBER 实现分页

假设有表TableA，字段为FieldA, FieldB，查询第10到20条记录，SQL如下：

select *
from
    (
        select row_number() over(order by FieldA) as RowNum, *
        from
            TableA
    ) t
where
  t.RowNum between 10 and 20