题解 | #牛客每个人最近的登录日期(二)#
牛客每个人最近的登录日期(二)
http://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
SELECT u.name AS u_n,c.name AS c_n,date
FROM login l JOIN user u ON l.user_id=u.id
JOIN client c ON l.client_id=c.id
AND date IN (SELECT MAX(date) FROM login WHERE l.user_id=login.user_id)
GROUP BY u.name
ORDER BY u.name
查看8道真题和解析