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;
|