[MySQL] LeetCode : Consecutive-Numbers

 

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

Consecutive Numbers - LeetCode

 

1. 코드 구현 (CTE 사용)

WITH TMP AS(
    SELECT id    
           ,num
           ,LAG(num, 1, NULL) OVER(ORDER BY id)AS num2 
           ,LAG(num, 2, NULL) OVER(ORDER BY id)AS num3
    FROM Logs
)

SELECT DISTINCT num AS ConsecutiveNums
FROM TMP 
WHERE num = num2 AND num2 = num3

 

 

2. 코드 구현 (FROM절 서브쿼리)

SELECT DISTINCT tmp.num AS ConsecutiveNums
FROM (
   SELECT id    
           ,num
           ,LAG(num, 1, NULL) OVER(ORDER BY id)AS num2 
           ,LAG(num, 2, NULL) OVER(ORDER BY id)AS num3
    FROM Logs
)tmp
WHERE tmp.num = tmp.num2 AND tmp.num2 = tmp.num3