题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
注意只用两个表,题目指明又登陆没有刷题的情况不记
select g.name,t.date,sum(number) over(partition by g.name order by t.date asc) from passing_number as t join user as g on t.user_id=g.id order by t.date,g.name;