Last updated on January 21st, 2025 at 10:58 pm

Here, we see the Consecutive Numbers LeetCode Solution. This Leetcode problem is solved using MySQL and Pandas.

List of all LeetCode Solution

Consecutive Numbers LeetCode Solution

1. Problem Statement

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:

Output:

Explanation: 1 is the only number that appears consecutively for at least three times.

2. Code Implementation in Different Languages

2.1 Consecutive Numbers 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;