题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
方法：窗口函数
select u.name,l.date,sum(number)over(partition by l.user_id order by l.date asc) as pc from login l inner join passing_number pn on l.user_id=pn.user_id and l.date=pn.date inner join user u on l.user_id=u.id order by l.date asc,u.name asc
查看1道真题和解析
