题解 | 牛客每个人最近的登录日期(六)
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
#累计求和-截至某一天 select u.name as u_n ,p.date as date ,sum(p.number)over(partition by u.name order by p.date)as ps_num from passing_number p left join user u on p.user_id=u.id order by p.date,u.name ;
