SQL codeselect * from (select *,row_number() over(ORDER BY trandate) as num from #t) aa where num between (@CurrPage-1)*@PageSize+1 and @CurrPage*@PageSize
...全文
592打赏收藏
求pl/sql分页存储过程
求pl/sql分页存储过程,能返回多行记录集,sqlserver是这样实现的,pl/sql怎样实现,求解: SQL codeselect * from (select *,row_number() over(ORDER BY trandate) as num from #t) aa where num between (@CurrPage-1)*@PageSize+1 and @CurrPage*@PageSize