后面再分析
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/questionTerminal/572a027e52804c058e1f8b0c5e8a65b4
先记着
select t2.name,t1.date,sum(t1.number) over(PARTITION BY user_id order by t1.date) from passing_number t1, user t2 where t1.user_id=t2.id order by t1.date,t2.name
查看5道真题和解析
