题解 | #牛客每个人最近的登录日期(五)#
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
思路:以刷题表为主表连接用户表,sum()over得到每个用户的每日累计刷题数
select
u.name u_n
,date
,sum(number)over(partition by p.user_id order by date) ps_num
from passing_number p
left join user u on p.user_id = u.id
order by 2,1
select
u.name u_n
,date
,sum(number)over(partition by p.user_id order by date) ps_num
from passing_number p
left join user u on p.user_id = u.id
order by 2,1
sql刷题笔记 文章被收录于专栏
sql刷题笔记,有思路的讲解,不过比较简单,可以稍微启发你一下,留给你一些思考的空间。