[leetcode_database]180. Consecutive Numbers
2021-02-28 13:09 作者:您是打尖兒還是住店呢 | 我要投稿
SQL Schema
Table:?Logs
https://leetcode.com/problems/consecutive-numbers/
方法一：做兩個鏈接；
方法二：使用自帶函數(shù)；
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
標簽：
