search

yokostan / Leetcode-Solutions

Doing exercise on Leetcode. Carry on!
0 stars 3 forks source link

Leetcode #180. Consecutive Numbers #211

Open yokostan opened 5 years ago

yokostan commented 5 years ago 
# Write your MySQL query statement below
SELECT DISTINCT log1.Num as ConsecutiveNums
FROM Logs log1, Logs log2, Logs log3
WHERE log1.Id = log2.Id - 1 AND log2.Id = log3.Id - 1
AND log1.Num = log2.Num AND log2.Num = log3.Num