题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select user.name, passing_number.date, sum(passing_number.number)over(partition by passing_number.user_id order by passing_number.date)
from passing_number left join user on passing_number.user_id=user.id
order by passing_number.date, user.name
from passing_number left join user on passing_number.user_id=user.id
order by passing_number.date, user.name
查看3道真题和解析
