select *from (
select row_number() over(partition by archiveTYpe order by operdate desc) as rownum ,* from archiveinfo
) as t where rownum between (((@pageindex-1)*@pagesize)+1) and (@pageindex*@pagesize)
select *from (
select row_number() over(partition by archiveTYpe order by operdate desc) as rownum ,* from archiveinfo
) as t where rownum between (((@pageindex-1)*@pagesize)+1) and (@pageindex*@pagesize)