[leetcode_database]180. Consecutive Numbers
2021-02-28 13:09 作者:您是打尖儿还是住店呢 | 我要投稿
SQL Schema
Table: Logs
https://leetcode.com/problems/consecutive-numbers/
方法一：做两个链接；
方法二：使用自带函数；
SELECT DISTINCT L1.Num AS ConsecutiveNums
FROM Logs L1, Logs L2, Logs L3
WHERE L1.Num = L2.Num AND L1.Num = L3.Num AND L1.Id = L2.Id + 1 AND L1.Id = L3.Id + 2
