Oracle 取出6至10行的记录

select * from (select a.*,rownum rn from aa a) a1 where a1.rn between 6 and 10;