Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
13. Repeated Values in Sequence (Medium)
On this page

Problem Statement

Table: Sequence

Each row in this table represents a sequence of numbers with a unique ID and a value for each position in the sequence.

+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| id          | int     |
| value       | int     |
+-------------+---------+
id is the primary key for this table.
This table may contain duplicate values in the 'value' column.

Develop a solution to find all values that appear at least three times consecutively in the sequence.

Return the result table in any order.

Example

Input:

`

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page