Posted by Mahesh BS on 07/13/06 16:13

Hello,



I need to write a query to find out a set of missing number in a given
sequence.



Eg : a Column in some table has the following data



Col1

1

2

3

4

5

6

8

9

10



Here I need to write a query to find out that number 7 is missing in the
given sequence.

One possible solution is by using any loop. But I am looking out if the same
can be achieved using any query.



Thanks in advance.



Regards,

Mahesh

• Next in forum: Re: Query to find a missing number
• Prev in forum: SQL 2000 Error: 1203, Severity: 20, State: 1 Error
• Thread view: Query to find a missing number

[Reply to this message]