select u.name u_n,p.date,sum(p.number) over(partition by u.id order by date)
from passing_number p
left join
user u
on p.user_id=u.id
order by p.date,u_n
  • 窗口函数结合sum和order by可以得到累加的效果