oracle分页查询

select *
  from (select rownum rn, a.*
          from (select * from CL_LOG order by log_id) a
         where rownum <= 100) where  rn > 0

posted @ 2015-06-30 13:00  大鹏520  阅读(159)  评论(0编辑  收藏  举报