Oracle中排序后查询20~40数据

第一种方法: select * from (select t.*,rownum tt from (select * from sup_doc_feedback order by web_doc_id)t where rownum <41) r where r.tt>20

第二中方法:select * from (select * from (select * from sup_doc_feedback t order by web_doc_id )  where rownum <41   minus
                                                  select * from (select * from sup_doc_feedback t order by web_doc_id )  where rownum< 21) order by web_doc_id


版权声明:本文为xiongli0204原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。