您好,请参考如下示例:
SELECT userid,
DATE_SUB(left(time,10),INTERVAL t.rn DAY) as flag_date,count(distinct left(time,10))
from (SELECT left(time,10),userid,time,DENSE_RANK() over(PARTITION by userid ORDER BY left(time,10)) as rn
from product_list_wp) as t
GROUP BY userid,flag_date
HAVING count(distinct left(time,10))>=3;
您好,请参考如下示例:
2021-10-04 16:11SELECT userid,
DATE_SUB(left(time,10),INTERVAL t.rn DAY) as flag_date,count(distinct left(time,10))
from (SELECT left(time,10),userid,time,DENSE_RANK() over(PARTITION by userid ORDER BY left(time,10)) as rn
from product_list_wp) as t
GROUP BY userid,flag_date
HAVING count(distinct left(time,10))>=3;