[LeetCode] Consecutive Numbers (MySQL)

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

Consecutive Numbers - LeetCode

row 3개 연속해서 등장하는 num을 찾는 문제.

 

1. Where IN 활용

select distinct Num as ConsecutiveNums from Logs
where (Id+1,Num) in (Select * from Logs) and (ID+2, Num) in (Select * from Logs)
;

 

2. self join 활용

SELECT distinct a.num ConsecutiveNums FROM
Logs a JOIN Logs b
on a.id = b.id - 1
JOIN logs c
on b.id = c.id - 1
WHERE a.num = b.num and b.num = c.num
;