oracle分页查询

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