Oracle 以某字段分组，以某字段排序，取前几条

select * from (select row_number() over(partition by select * from (select row_number() over(par