题解 | 牛客每个人最近的登录日期(六)
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select
t1.name as u_n,
t2.date as date,
coalesce(t2.num, 0) as ps_num
from user t1
inner join
(select
user_id,
date,
sum(number) over(partition by user_id order by date asc)as num
from passing_number) t2
on t1.id=t2.user_id
order by t2.date asc,t1.name asc
查看14道真题和解析