题解 | 牛客每个人最近的登录日期(二)
牛客每个人最近的登录日期(二)
https://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
select
a.u_n,
a.c_n,
a.date
from
(
select u.name as u_n,c.name as c_n,date,row_number() over(partition by user_id order by date desc) as rd from login as l
join
user as u
on
l.user_id=u.id
join
client as c
on
l.client_id=c.id
) as a
where
rd=1
order by
a.u_n
滴滴公司福利 1815人发布