例如:
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
这样分页就简单啦 嘿嘿...
例如:
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
这样分页就简单啦 嘿嘿...
转载于:https://www.cnblogs.com/hezechang/archive/2008/10/28/1321688.html