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

select u.name as u_n, c.name as c_n, date as date
from login l join user u on l.user_id = u.id 
join client c on l.client_id = c.id
where (l.user_id, date) in (
    select user_id,max(date)
    from login
    group by
        user_id)
order by
    u.name ASC;