题解 | 牛客每个人最近的登录日期(六)
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select u.name as u_n,p.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_n
学会：累计求和表达式 sum(求和列)over(partition by 分区列 order by 排序列)
查看7道真题和解析