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

select t.name as u_n ,name1 as c_n,date
from (
    select u.name ,c.name as name1 ,date,row_number() over (partition by u.name order by  date desc ) as rk
    from login join user u on login.user_id = u.id
    join client c on c.id = login.client_id

     ) as t
where rk=1
order by name