MS-SQL2005使用ROW_NUMBER进行效率分页

SELECT *
FROM (select *,ROW_NUMBER() Over(order by id) as rowNum from table_info ) as myTable
where rowNum between 50 and 60;
posted on 2009-11-12 13:41  小菜鸟软件学习  阅读(245)  评论(0)  编辑  收藏  举报