SQL-180. 连续出现的数字

# Write your MySQL query statement below
# 编写一个 SQL 查询，查找所有至少连续出现三次的数字。返回的结果表中的数据可以按 任意顺序 排列。
# row_number() over([partition by value_expression,...n] order by columnName)

# Write your MySQL query statement below

# 自连接
SELECT DISTINCT l1.Num as ConsecutiveNums
FROM Logs l1
JOIN Logs l2
ON l1.id = l2.id - 1
JOIN Logs l3
ON l2.id = l3.id - 1
WHERE l1.Num = l2.Num
And l2.Num = l3.Num

SELECT DISTINCT
    l1.Num AS ConsecutiveNums
FROM
    Logs l1,
    Logs l2,
    Logs l3
WHERE
    l1.Id = l2.Id - 1
    AND l2.Id = l3.Id - 1
    AND l1.Num = l2.Num
    AND l2.Num = l3.Num
;