Detect Gaps in ID Sequence

MediumSQL · PostgreSQL

Problem

Write a SQL query to identify gaps in a sequence of IDs.

Use the sequence_records table. Treat the complete sequence as every integer from the minimum non-null ID through the maximum non-null ID, inclusive. Ignore null IDs.

Output

Return one row per missing ID with the column missing_id.
Sort the results by missing_id in ascending order.

Schema

sequence_records

Column	Type	Description
record_keyPK	INT	Unique row identifier
sequence_id	INT	Integer ID whose sequence is being checked

Tablessequence_records

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.