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

Select u.name,c.name,date
From login l join user u on l.user_id=u.id
    join client c on l.client_id=c.id
Where (user_id, date) in (
select user_id,max(date) d
from login
group by user_id
order by user_id
)
order by u.name