Last updated on October 10th, 2024 at 12:02 am

This Leetcode problem Consecutive Numbers LeetCode Solution is done in SQL.

List of all LeetCode Solution

Consecutive Numbers LeetCode Solution

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.

1. 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;