SQL 分页脚本

declare @pagesize int 
declare @pagenum int

select top (@pagesize) * from (
    select top (@pagesize*@pagenum) ROW_NUMBER() over(order by columnA ) as rownum,count(1) over() as totalcount,columnB,columnC 
    from exampletableA where columnA=‘‘ 
 )exampletable 
 where rownum between (@pagenum-1)*@pagesize+1 and @pagesize*@pagenum
 order by rownum