180. 连续出现的数字

SQL架构

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

+----+-----+
| Id | Num |
+----+-----+
| 1  |  1  |
| 2  |  1  |
| 3  |  1  |
| 4  |  2  |
| 5  |  1  |
| 6  |  2  |
| 7  |  2  |
+----+-----+

例如，给定上面的 Logs 表， 1 是唯一连续出现至少三次的数字。

+-----------------+
| ConsecutiveNums |
+-----------------+
| 1               |
+-----------------+

# Write your MySQL query statement below

select  distinct a.num as ConsecutiveNums
from logs a ,logs b ,logs c where  a.id+1 = b.id and  b.id+1 = c.id
and a.num = b.num and b.num = c.num;


如果不加distinct进行去重，：实例输入数据:
输入：
{"headers": {"Logs": ["Id", "Num"]}, "rows": {"Logs": [[1, 3], [2, 3], [3, 3], [4, 3]]}}
输出：
{"headers": ["ConsecutiveNums"], "values": [[3], [3]]}
预期结果：
{"headers":["ConsecutiveNums"],"values":[[3]]}