Oracle数据库分组排序

select  row_number() over(partition by oea03 order by oea02 desc) num,oea01,oea02,oea03 from oea_file;