Oracle中Rownum排序

  用

    select      *  
    from        kkkk A
    WHERE 1=1      and instr(SLJJDW, '4401') >0
                                 and SLJJDW like '4401'||'%'
                                 and 6>ROWNUM    
  order by SLJJSJ desc

无法正常排序

需要写成

 select t.*,rownum from  (

    select      *  
    from        kkkk  A
    WHERE 1=1      and instr(SLJJDW, '4401') >0
                                 and SLJJDW like '4401'||'%'
    order by SLJJSJ desc

                                          ) t 

where 6>ROWNUM