select * from (select temp.*,rownum rn from (select * from tables )temp) where rownum <10 and rownum >1
根据查询理论，应尽快过滤结果提高查询效率，因此可提早设定rownum范围
select * from (select temp.*,rownum rn from (select * from tables )temp where rn <100 ) where rownum >1
select * from (select temp.*,rownum rn from (select * from tables )temp) where rownum <10 and rownum >1
select * from (select temp.*,rownum rn from (select * from tables )temp where rn <100 ) where rownum >1
