Consecutive Numbers - Problem
You are given a Logs table with an auto-incrementing id starting from 1 and a num column containing various numbers.
Find all numbers that appear at least three times consecutively.
Return the result in any order. The result should contain only the distinct numbers that meet this criteria.
Table Schema
Logs
| Column Name | Type | Description |
|---|---|---|
id
PK
|
int | Primary key, auto-incrementing starting from 1 |
num
|
varchar | Number value that may appear consecutively |
Primary Key: id
Note: The id column represents consecutive row positions starting from 1
Input & Output
Example 1 — Basic Consecutive Pattern
Input Table:
| id | num |
|---|---|
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 2 |
| 5 | 1 |
Output:
| ConsecutiveNums |
|---|
| 1 |
💡 Note:
The number 1 appears in rows with consecutive IDs 1, 2, and 3. This satisfies the requirement of appearing at least three times consecutively.
Example 2 — No Consecutive Pattern
Input Table:
| id | num |
|---|---|
| 1 | 1 |
| 2 | 2 |
| 3 | 1 |
| 4 | 2 |
| 5 | 1 |
Output:
| ConsecutiveNums |
|---|
💡 Note:
No number appears three times consecutively. Each number alternates, so the result is empty.
Example 3 — Multiple Consecutive Patterns
Input Table:
| id | num |
|---|---|
| 1 | 3 |
| 2 | 3 |
| 3 | 3 |
| 4 | 3 |
| 5 | 5 |
| 6 | 5 |
| 7 | 5 |
Output:
| ConsecutiveNums |
|---|
| 3 |
| 5 |
💡 Note:
The number 3 appears four times consecutively (rows 1-4) and 5 appears three times consecutively (rows 5-7). Both numbers qualify.
Constraints
-
1 ≤ id ≤ 1000 -
numis a varchar that can contain any string value -
The
idcolumn is auto-incrementing and starts from 1
Visualization
Tap to expand
Understanding the Visualization
1
Input
Table with id and num columns
2
Pattern Detection
Find 3+ consecutive identical values
3
Output
Distinct consecutive numbers
Key Takeaway
🎯 Key Insight: Use self-joins or window functions to compare values across consecutive table rows
💡
Explanation
AI Ready
💡 Suggestion
Tab
to accept
Esc
to dismiss
// Output will appear here after running code