sql 2005 row_number分页
时间：2011-05-10 来源：蓝丶 sky
declare @pagesize int,@currentpage int
set @pagesize=10--每页显示数量--
set @currentpage=2--当前页--
;with cte as (
select row_number() over(order by id desc) as number,* from DS_Brand
)
select * from cte where number between (@currentpage-1)*@pagesize+1 and @currentpage*@pagesize
相关阅读 更多 +
