This Leetcode problem Consecutive Numbers LeetCode Solution is done in SQL.
List of all LeetCode Solution
Consecutive Numbers LeetCode Solution
Table of Contents
Problem Statement
Column Name | Type |
id | int |
num | varchar |
Logs
In SQL, id is the primary key for this table. id is an autoincrement column.
Find all numbers that appear at least three times consecutively.
Return the result table in any order.
The result format is in the following example.
Example 1:
Input:
id | num |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 2 |
5 | 1 |
6 | 2 |
7 | 2 |
Output:
ConsecutiveNums |
1 |
Explanation: 1 is the only number that appears consecutively for at least three times.
Consecutive Numbers LeetCode Solution MySQL
select
distinct Num as ConsecutiveNums
from
(
select
Num,
@cnt := if(
@prev = (@prev := Num),
@cnt + 1,
1
) as freq
from
Logs,
(
select
@cnt := 0,
@prev := (
select
Num
from
Logs
limit
1
)
) as c
) as n
where
freq > 2;
Code language: SQL (Structured Query Language) (sql)