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