Oracle中间数据查询

中间数据查询

查询中间数据，去除前n条后n条数据

     select t.*
     from 
     (
        select rownum as rn , * 
        from a
        where rn>30
     ) t
     where rownum>30
     order by rn desc