SQL每日一题(20211214)希望查询出至少连续出现4次的数字

SELECT NUM
FROM (SELECT *,ROW_NUMBER() over (order by ID) a ,
             ROW_NUMBER() over (PARTITION BY NUM ORDER BY ID) b ,
             ROW_NUMBER() over (order by ID) - ROW_NUMBER() over (PARTITION BY NUM ORDER BY ID) FZ FROM T1214) T1
GROUP BY FZ, NUM
HAVING COUNT(*) >3