2021-06-08--leetcode 连续出现的数字

leetcode 数据库
180. 连续出现的数字

select distinct l1.Num as ConsecutiveNums 
from Logs l1 join logs l2 on l1.id = l2.id-1 
join logs l3 on l1.id = l3.id+1 
where l1.Num=l3.Num and l1.Num=l2.Num

步骤解析：
表l1:
| 表l1join表l2.id-1

表l1joinl3.id+1

最后的盛夏的数据为1

**

解法二

**

SELECT DISTINCT Num AS ConsecutiveNums FROM Logs 
WHERE (Id+1, Num) IN (SELECT * FROM Logs)
AND (Id+2, Num) IN (SELECT * FROM Logs)

这是一个