Oracle分页查询

当有排序时oracle分页查询

 select *
   from (select rownum r, t.*
           from (select * from DATA_SCHEME_SCHEDUL order by update_time desc) t
          where rownum <= 5)
  where r > 0

 

posted on 2020-03-26 21:40  song.yan  阅读(186)  评论(0)  编辑  收藏  举报