题解 | #牛客每个人最近的登录日期(四)#
牛客每个人最近的登录日期(四)
http://www.nowcoder.com/practice/e524dc7450234395aa21c75303a42b0a
1.分析
https://blog.nowcoder.net/n/a2f955514f824bb888f9d7726421e809?f=comment
select login.date,ifnull(n1.new_num,0) from login left join (select l1.date,count(distinct l1.user_id) as new_num from login l1 where l1.date = (select min(date) from login where user_id=l1.user_id) group by l1.date) n1 on login.date = n1.date group by login.date order by login.date
查看3道真题和解析