devxlogo

Find Missing Numbers in a Sequence

Find Missing Numbers in a Sequence

There are several cases where you may write algorithms only to find missing numbers in a sequence. There is an efficient way to do this. Let’s say you have a table like this:

 Mynum-----1346791016

Here is the script to create the table and insert sample data.

 --DROP TABLE #testCREATE TABLE #test(mynum INT)INSERT INTO #test VALUES (1)INSERT INTO #test VALUES (3)INSERT INTO #test VALUES (4)INSERT INTO #test VALUES (6)INSERT INTO #test VALUES (7)INSERT INTO #test VALUES (9)INSERT INTO #test VALUES (10)INSERT INTO #test VALUES (16)--SELECT * FROM #testSELECT A.mynum+1 AS 'MissingFROM', MIN(B.mynum)-1 AS 'TO'FROM #test A, #test B	WHERE A.mynum < B.mynum	GROUP BY A.mynum	HAVING A.mynum + 1 < MIN(B.mynum)	ORDER BY 1
See also  11 Effective Keyword Research Tools and Techniques
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist