题解 | #牛客每个人最近的登录日期(二)#
牛客每个人最近的登录日期(二)
https://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
SELECT u.name,c.name,l.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,l.date) IN
(SELECT user_id,MAX(date)
FROM login
GROUP BY user_id)
查看9道真题和解析