select * from (select A.*,rownum rn from ( 原MysqL的语句，注意去掉limit )A where rownum > 30 ) where rn < 20 原文链接：https://www.f2er.com/oracle/212434.html
select * from (select A.*,rownum rn from ( 原MysqL的语句，注意去掉limit )A where rownum > 30 ) where rn < 20 原文链接：https://www.f2er.com/oracle/212434.html