题解 | #牛客每个人最近的登录日期(六)#
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/practice/572a027e52804c058e1f8b0c5e8a65b4
select
*
from(
select
n.name
,l.date
,sum(p.number) over(partition by l.user_id order by l.date) s
from login l
join user n
on l.user_id = n.id
left join passing_number p
on l.user_id = p.user_id
and l.date = p.date
) a2
where a2.s is not null
order by a2.date,a2.name
查看30道真题和解析