牛客485505005号

题解

/ 注册

全部文章 / 题解（共2篇）

题解 | MYsql 开窗函数#牛客每个人最近的登录日期(三)#

select date,sum(case when date=d then 1 else 0 end)from (select * ,min(date) over(partition by user_id) d from login) as agroup by dateorder by ...

2021-05-21

0 479

题解 | #MYSQL开窗函数#

SELECT round( sum( CASE WHEN date = date_add( d, INTERVAL 1 DAY ) THEN 1 ELSE 0 END )* 1 / sum( CASE WHEN date = d THEN 1 ELSE 0 END ...

2021-05-20

16 1501