SQL:编写一个 SQL 查询，查找所有至少连续出现三次的数字

logs

1

1

1

2

1

2

2

SELECT distinct A.Num as ConsecutiveNums
FROM
    Logs A,
    Logs B,
    Logs C
WHERE
    A.Id = B.Id - 1
    AND B.Id = C.Id - 1
    AND A.Num = B.Num
    AND B.Num = C.Num