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