Oracle数据库分组排序 select row_number() over(partition by oea03 order by oea02 desc) num,oea01,oea02,oea03 from oea_file;