题解 | 牛客每个人最近的登录日期(二)
牛客每个人最近的登录日期(二)
https://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
select b.name as u_n, c.name as c_n, a.date
from (
select user_id, client_id, date
from login
where (user_id, date) in (
select user_id, max(date)
from login
group by user_id
)
) a
join user b on a.user_id=b.id
join client c on a.client_id=c.id
order by b.name
