Oracle中rownum与order by的执行顺序正确的写法应该是：先order by，先包一层查询，再赋rownum值-JZTXT

Oracle中rownum与order by的执行顺序正确的写法应该是：先order by，先包一层查询，再赋rownum值
原文链接：https://blog.csdn.net/u013456370/article/details/122366975


select id,createdate,finvoutype from nc_ext_fa_ls_pz_hzdoc doc 
      where doc.company = '3000004' and doc.finvoutype = 'YUFZXD' 
      and doc.gxmlflag = '20220107' 
      and rownum <=10 order by doc.createdate

第一种方法：id:6321 没取值出来；


select id from (
select id from nc_ext_fa_ls_pz_hzdoc doc 
      where doc.company = '3000004' and doc.finvoutype = 'YUFZXD' 
      and doc.gxmlflag = '20220107' 
       order by doc.createdate) where  rownum <=10