10000 🟡 Solve problem 180 · AF2B/Leetcode@1879a5f · GitHub
[go: up one dir, main page]
Skip to content

Commit 1879a5f

Browse files
AF2BAF2B
committed
🟡 Solve problem 180
1 parent 4ce3a59 commit 1879a5f

File tree

1 file changed

+6
-0
lines changed

1 file changed

+6
-0
lines changed

‎sql/180.sql

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
SELECT DISTINCT num AS ConsecutiveNums
2+
FROM Logs l1
3+
WHERE
4+
(SELECT num FROM Logs l2 WHERE l2.id = l1.id + 1) = l1.num
5+
AND
6+
(SELECT num FROM Logs l3 WHERE l3.id = l1.id + 2) = l1.num;

0 commit comments

Comments
 (0)
0