0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

CREATE TABLE #table(

    ID  int 
);


INSERT INTO #table VALUES
(4),
(5),
(10);


SELECT TOP 1 t1.Id+1 as ID
FROM #table t1
WHERE NOT EXISTS(SELECT * FROM #table t2 WHERE t2.Id = t1.Id + 1)
ORDER BY t1.Id


DROP TABLE #table;

fork query

edited nov 11

created jul 22 16 anonymous