Error - View Single Post - SQL Query to find missing numbers in a sequence of numbers

**Anilrgowda** · 22-Oct-2007, 12:52 AM

Select Top 1 YourNumber + 1 from YourTable T1
where not exists
(select * from YourTable T2 where T2.YourNumber = T1.YourNumber + 1)
order by YourNumber asc

22-Oct-2007, 12:52 AM	#2 (permalink)
Anilrgowda Administrator Posts: 18,715 Join Date: Jan 2006 Rep Power: 10 IM:	Re: SQL Query to find missing numbers in a sequence of numbers Select Top 1 YourNumber + 1 from YourTable T1 where not exists (select * from YourTable T2 where T2.YourNumber = T1.YourNumber + 1) order by YourNumber asc ------------------