| Subject | Obtaining the minor number that does not exist |
|---|---|
| Author | Ismael L. Donis García |
| Post date | 2010-09-01T16:34:58Z |
Is it possible to obtain by means of a consultation the minor number that does not exist in a status of numbers?
For Example:
Table.Id
1
2
4
5
8
9
....
select a.id from table a where a.id between 1 and 1000000
Desire than of as a Result = 3
Regards
=========
|| ISMAEL ||
=========
[Non-text portions of this message have been removed]
For Example:
Table.Id
1
2
4
5
8
9
....
select a.id from table a where a.id between 1 and 1000000
Desire than of as a Result = 3
Regards
=========
|| ISMAEL ||
=========
[Non-text portions of this message have been removed]