题解 | #牛客每个人最近的登录日期(四)#
牛客每个人最近的登录日期(四)
https://www.nowcoder.com/practice/e524dc7450234395aa21c75303a42b0a
select date,sum(r) from(select *,if(rank() over (partition by user_id order by date asc)=1,1,0) r from login) l group by date
牛客每个人最近的登录日期(四)
https://www.nowcoder.com/practice/e524dc7450234395aa21c75303a42b0a
select date,sum(r) from(select *,if(rank() over (partition by user_id order by date asc)=1,1,0) r from login) l group by date
相关推荐