sqlsqler2005下读取某分页段记录数

sqlsqler2005版本增加类似Oracle一样的伪列方法 ROW_NUMBER()OVER(ORDER BY [id] ASC)
id为表的自增列

例如：读取表MASTERDATA中10到20行的记录数
select * from (select (ROW_NUMBER()OVER(ORDER BY [id] ASC)) as ROWID,* from MASTERDATA) as d where d.ROWID BETWEEN 10 AND 20