题解 | #牛客每个人最近的登录日期(二)#

select
    t.u_n,
    t.c_n,
    t.date
from
    (
        select
            l.date date,
            c.name c_n,
            u.name u_n,
            dense_rank() over (
                partition by
                    user_id
                order by
                    date desc
            ) rk
        from
            login l
            left join user u on l.user_id = u.id
            join client c on l.client_id = c.id
    ) t
where
    t.rk = 1
order by t.u_n asc