FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
LeetCode-Solutions/MySQL/consecutive-numbers.sql at master · pythonpeixun/LeetCode-Solutions · GitHub
pythonpeixun
/
LeetCode-Solutions
Public
forked from
kamyu104/LeetCode-Solutions
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
consecutive-numbers.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
17 lines (14 loc) · 447 Bytes
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
consecutive-numbers.sql
Copy path
File metadata and controls
17 lines (14 loc) · 447 Bytes
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
#
Time: O(n)
#
Space: O(n)
SELECT DISTINCT
(Num)
AS
ConsecutiveNums
FROM
(
SELECT
Num,
@counter :
=
IF(@prev
=
Num, @counter
+
1
,
1
)
AS
how_many_cnt_in_a_row,
@prev :
=
Num
FROM
Logs y, (
SELECT
@counter:
=
1
, @prev:
=
NULL
) vars
) sq
WHERE
how_many_cnt_in_a_row
>=
3
SELECT DISTINCT
l1
.
Num
as
ConsecutiveNums
FROM
Logs l1, Logs l2, Logs l3
WHERE
l1
.
Id
+
1
=
l2
.
Id
AND
l2
.
Id
+
1
=
l3
.
Id
AND
l1
.
Num
=
l2
.
Num
AND
l2
.
Num
=
l3
.
Num
Back
|
FazBrowse Home
|
New Git URL