题解 | 牛客每个人最近的登录日期(二)
牛客每个人最近的登录日期(二)
https://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
SELECT
u.name AS u_n,
c.name AS c_n,
l.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, l.date) IN (
SELECT user_id, MAX(date)
FROM login
GROUP BY user_id
)
ORDER BY u.name;
滴滴公司福利 1784人发布
查看1道真题和解析