SQL2005 分页方法 ROW_NUMBER


例如:

select * from
(select ROW_NUMBER() OVER(ORDER BY A.id) as rownum,A.*
from (select id,字段1,字段2,... from table1)as A
)as B where B.rownum between @pagesize*(@page-1)+1 and @pagesize*@page


这样分页就简单啦 嘿嘿...

posted @ 2008-10-28 22:11  HEZECHANG  阅读(181)  评论(1)  编辑  收藏  举报