题解 | #牛客每个人最近的登录日期(二)#
牛客每个人最近的登录日期(二)
https://www.nowcoder.com/practice/7cc3c814329546e89e71bb45c805c9ad
select
t2.name u_n
,t3.name c_n
,date
from login t1 left join user t2
on t1.user_id = t2.id
left join client t3
on t1. client_id = t3.id
where
(t1.user_id,t1.date) in
(
select user_id,max(date)
from login
group by user_id
)
order by 1
查看1道真题和解析