使用开窗便可解决
select id,count(rn)as num from(
select *,date_sub(date,interval row_number() over (partition by id order by date) day ) as rn
from date_table
) t group by id,rn having count(rn)>=3;
使用开窗便可解决
select id,count(rn)as num from(
select *,date_sub(date,interval row_number() over (partition by id order by date) day ) as rn
from date_table
) t group by id,rn having count(rn)>=3;