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

select
    u_n,
    c_n,
    date
from
    (
        select
            u.name as u_n,
            c.name as c_n,
            date,
            row_number() over (partition by u.name order by date desc) as rn
        from
            login l
            inner join user u on l.user_id = u.id
            inner join client c on l.client_id = c.id
    ) a
where
    rn = 1