27,579
社区成员
发帖
与我相关
我的任务
分享
;WITH f1 AS
(
SELECT *,case when 平均温度<=1.0 AND 日雨量>=0.0 AND 最低气温<=0.0 then 1 else 0 end as Y,
ROW_NUMBER() OVER(ORDER BY YYYYMMDD) re
FROM tb
)
,f2 AS
(
SELECT *,re-ROW_NUMBER() OVER(PARTITION BY Y ORDER BY re) re2
FROM f1
)
SELECT count(1)
FROM f2
GROUP BY re2
HAVING COUNT(*)>=3