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