180. Consecutive Numbers : leetcode

SELECT  DISTINCT l1.num as ConsecutiveNums
FROM    Logs l1 INNER JOIN Logs l2 ON l2.id = l1.id + 1 AND l1.num = l2.num
        INNER JOIN Logs l3 ON l3.id = l2.id + 1 AND l2.num = l3.num

WINDOW 함수를 사용하면

WITH CTE AS (
    SELECT  num,
            lead(num, 1) OVER() as num2,
            lead(num, 2) OVER() as num3
    FROM    Logs
)

SELECT  DISTINCT num as ConsecutiveNums
FROM    CTE
WHERE   num = num2 AND num = num3