Consecutive Numbers SQL | Dataford Interview Questions

Write a SQL query to find three consecutive numbers in a dataset.

Assume the table is sequence_values, where position_id identifies the sequence position and number_value stores the number. Return each non-null number that appears at three consecutive positions, even when the same number appears in multiple qualifying runs.

Output

One row per distinct qualifying number, named consecutive_number.
Include only numbers present at three successive position_id values.
Sort the results by consecutive_number in ascending order.

Schema

sequence_values

Column	Type	Description
position_idPK	INT	Sequence position used to determine adjacency
number_value	INT	Number recorded at the sequence position

Your question is Consecutive Numbers SQL. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Write a SQL query to find three consecutive numbers in a dataset.

Output

One row per distinct qualifying number, named consecutive_number.
Include only numbers present at three successive position_id values.
Sort the results by consecutive_number in ascending order.

Schema

sequence_values

Column	Type	Description
position_idPK	INT	Sequence position used to determine adjacency
number_value	INT	Number recorded at the sequence position

Your question is Consecutive Numbers SQL. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.