SQL 문제 40 - Consecutive Numbers LeetCode 180

SQL 문제 40 - Consecutive Numbers LeetCode 180 Consecutive Numbers 풀이 SELECT DISTINCT T.NUM AS ConsecutiveNums FROM ( SELECT LAG(NUM) OVER(ORDER BY ID ASC) AS P_NUM , NUM , LEAD(NUM) OVER(ORDER BY ID ASC) AS N_NUM FROM LOGS ) T WHERE T.NUM = T.P_NUM AND T.NUM = T.N_NUM; 특정 값 기준, LAG와 LEAD를 통해 이전 / 이후 값을 찾는 풀이다. * 출처 Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com...

원문링크 : SQL 문제 40 - Consecutive Numbers LeetCode 180