题解 | 牛客每个人最近的登录日期(六)
牛客每个人最近的登录日期(六)
https://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select user.name u_n, p.date date, sum(p.number)over(partition by user.name order by date) ps_num from passing_number p join user on p.user_id= user.id order by date,user.name
不用连接登陆表
