题解 | #牛客每个人最近的登录日期(二)#
牛客每个人最近的登录日期(二)
http://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
Select u.name,c.name,date
From login l join user u on l.user_id=u.id
join client c on l.client_id=c.id
Where (user_id, date) in (
select user_id,max(date) d
from login
group by user_id
order by user_id
)
order by u.name
科大讯飞公司氛围 472人发布