| how to find missing numbers [message #315366] |
Mon, 21 April 2008 05:25  |
RAY_HT
Messages: 155
Registered: May 2005
Location: Giza
|
Senior Member |
|
|
Hi All
i have a table with many vouchers inserted .
i want to search for missing sequence numbers in Rang
EX. if the table have this vouchers numbers ( 1,3,4,5,8 )
i want to get the missing numbers between 1 and 10 which is (2,6,7,9,10)
how can i get .
thanks in advance
|
|
|
|
| Re: how to find missing numbers [message #315369 is a reply to message #315366] |
Mon, 21 April 2008 05:32  |
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
|
Senior Member |
|
|
Hi
You have posted in the SQL Experts forum. This implies that you consider yourself to be an expert and that you consider this problem to be of an expert level. One thing that an expert would most definitely have done would have been to try several possible solutions themselves prior to asking for assistance. So why don't you post what you have already done, maybe someone can spot where you went wrong.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
