180. Consecutive Numbers / LeetCode, SQL, MySQL

문제

source: LeetCode

 

 

 

 

제출답안(MySQL)

SELECT DISTINCT(l1.num) AS ConsecutiveNums
FROM 
    logs AS l1
    JOIN logs AS l2 ON l1.id = l2.id+1
    JOIN logs AS l3 ON l1.id = l3.id+2
WHERE l1.num = l2.num AND l1.num = l3.num

 

 

 

문제 바로가기(MySQL)