카테고리 없음
180. Consecutive Numbers
semper.fidelis
2022. 8. 31. 22:28
반응형
```
SELECT DISTINCT
l1.Num AS ConsecutiveNums
FROM
Logs l1,
Logs l2,
Logs l3
WHERE
l1.Id = l2.Id - 1
AND l2.Id = l3.Id - 1
AND l1.Num = l2.Num
AND l2.Num = l3.Num
;```
반응형