Leetcode : 180. Consecutive Numbers

https://leetcode.com/problems/consecutive-numbers/

Consecutive Numbers - LeetCode

 

Multiple Self JOIN

SELECT L.NUM AS ConsecutiveNums
FROM LOGS L
JOIN LOGS L2 ON L.ID + 1 = L2.ID
JOIN LOGS L3 ON L.ID + 2 = L3.ID
WHERE L.NUM = L2.NUM = L3.NUM

 

Using Window Function

SELECT DISTINCT N1 AS ConsecutiveNums
FROM (
SELECT NUM AS N1, LEAD(1, NUM) OVER(ORDER BY ID) AS N2, LEAD(2, NUM) OVER(ORDER BY ID) AS N3
FROM LOGS)
WHERE N1 = N2= N3