sql 2005 分页

最佳答案

declare @pagesize int,@pageNum int
set @pagesize=10
set @pageNum=2

select * from (
select *,row_number() over(order by badge) rn  
from 表) a
where rn between @pagesize*(@pageNum-1) and @pagesize*(@pageNum)-1