MSSQL2005使用ROW_NUMBER进行效率分页 SELECT * FROM (select *,ROW_NUMBER() Over(order by id) as rowNum from table_info ) as myTablewhere rowNum between 50 and 60;