oracle分组排序取出每组顺序第一条

-- oracle分组排序取出每组顺序第一条
select * from (
    select
        row_number() over(partition by user_code order by create_time desc) rn,
        t.*
    from your_table t
) where rn = 1