반응형
목록 LeetCode : Consecutive-Numbers (1)
KEEP GOING

https://leetcode.com/problems/consecutive-numbers/ Consecutive Numbers - LeetCode 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 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..
code review/sql
2022. 2. 7. 16:20