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

*List of all LeetCode Solution*

*List of all LeetCode Solution*

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

*Consecutive Numbers LeetCode Solution MySQL*

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