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