题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select
u.name as u_n,
pn.date,
sum(pn.number) over(partition by pn.user_id order by pn.date)
from login l
join passing_number pn
using(user_id,date)
join user u
on l.user_id = u.id
order by pn.date,u.name
查看12道真题和解析
