MSSQL2005使用ROW_NUMBER进行效率分页

SELECT *
FROM (select *,ROW_NUMBER() Over(order by id) as rowNum from table_info ) as myTable
where rowNum between 50 and 60;