SQLize Online / PHPize Online  /  SQLtest Online

with tbl as ( SELECT 1 as id from dual union all SELECT 2 as id from dual union all SELECT 3 as id from dual union all SELECT 4 as id from dual union all SELECT 5 as id from dual union all SELECT 7 as id from dual union all SELECT 10 as id from dual ) SELECT CAST(V2.id + 1 AS INTEGER) AS missing_value FROM (SELECT T1.id, LEAD(T1.id) OVER (ORDER BY T1.id) id_plus_one FROM tbl T1) V2 WHERE V2.id_plus_one > V2.id + 1 UNION SELECT MIN(id) + 1 AS missing_value FROM tbl WHERE MIN(id) + 1 NOT IN (SELECT id FROM tbl);