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

While Shanalal Kasims solution is cool, it doesn't work when you have a larger gap in the sequence.This is pure SQL and should work for all cases:WITH M AS ( SELECT Max(SEQUENCE) s FROM table1 WHERE id = 1 ),numbers(n) AS ( SELECT 1 AS n UNION ALL...