Consecutive Numbers(Window함수)

SELECT DISTINCT L.NUM AS ConsecutiveNums
FROM (
     SELECT NUM
          , LEAD(NUM, 1) OVER (ORDER BY ID) AS NEXT
          , LEAD(NUM, 2) OVER (ORDER BY ID) AS AFTERNEXT
     FROM LOGS
) L
WHERE L.NUM = L.NEXT AND L.NUM = L.AFTERNEXT

SELECT DISTINCT L.NUM AS ConsecutiveNums
FROM LOGS L
    INNER JOIN LOGS F ON L.ID + 1 = F.ID
    INNER JOIN LOGS S ON L.ID + 2 = S.ID
WHERE L.NUM = F.NUM 
    AND L.NUM = S.NUM