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*

*List of all LeetCode Solution*

## Level of Question

Medium

**Consecutive Numbers LeetCode Solution**

## Table of Contents

**Problem Statement**

Column Name | Type |

id | int |

num | varchar |

**Table:**

`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 |

**Logs table:**

**Output:**

ConsecutiveNums |

1 |

**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;