题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select name u_n,t2.date date,
(select sum(number) ps_num from passing_number t1
where t1.user_id=t2.user_id
and t1.date<=t2.date)
from passing_number t2
join user
on t2.user_id=user.id
order by date,u_n;
查看8道真题和解析