mssql2005后基于row_number()的分页话语

mssql2005后基于row_number()的分页语句

?

select x.id,x.name from (select ROW_NUMBER() over(order by id) as rowNum,* from xx) as x where x.rowNum >0 and x.rowNum <=1000