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

来源:互联网 发布:阿里大数据竞赛 编辑:程序博客网 时间:2024/06/06 15:04

第一种方法: 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

原创粉丝点击