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