Oracle分组最大值数据

select * from 
(select t.*, row_number() over(partition by 分组字段 order by 排序字段 desc ) rn 
from tablename t ) 
where rn=1

 

记录一下