#107. [LeetCode / MySQL] 180. Consecutive Numbers

문제 입력 코드 1. SELECT DISTINCT a.num AS ConsecutiveNums FROM Logs AS a JOIN Logs AS b ON (a.id = b.id + 1) AND (a.num = b.num) JOIN Logs AS c ON (b.id = c.id + 1) AND (b.num = c.num) 2. WITH cte AS ( SELECT num, LAG(num) OVER (ORDER BY id) AS prev_num, LEAD(num) OVER (ORDER BY id) AS next_num FROM Logs ) SELECT num AS ConsecutiveNums FROM cte WHERE num = prev_num AND num = next_num GROUP BY num; 코드..