oracle分组排序取第一条数据

row_number()over(partition by  分组字段 order by  排序字段)

例：select * from (
select id,dealer_name,row_number()over(partition by dealer_name order by create_time ) r from mr) where r=1