题解 | #牛客每个人最近的登录日期(二)#
牛客每个人最近的登录日期(二)
https://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
select user.name, client.name, login.date from login left join client on login.client_id = client.id left join user on login.user_id = user.id where (login.user_id, login.date) in ( SELECT user_id, MAX(date) AS latest_login FROM login GROUP BY user_id ) order by user.name, login.date DESC