1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

-- @Title: 连续出现的数字 (Consecutive Numbers)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 16:24:10
-- @Runtime: 418 ms
-- @Memory: 0 B
# Write your MySQL query statement below

SELECT DISTINCT L1.num 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;