How to find a gap in the table between min and max value using pure SQL

select sequence from SequenceTable where sequence NOT IN (select sequence FROM Table1 WHERE id=8)I've created another table named SequenceTable and stored value from 1 to 10 and then applying the above query.