oracle ROW_NUMBER 和 ROWNUM

select row_number () over (order by rownum desc) as rn,rownum,aaa from aaaa
/