Home » SQL & PL/SQL » SQL & PL/SQL » how to find missing numbers
how to find missing numbers [message #315366] Mon, 21 April 2008 05:25 Go to next message
Messages: 153
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 Go to previous messageGo to next message
Messages: 2844
Registered: May 2007
Location: Scotland
Senior Member
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.
Re: how to find missing numbers [message #315372 is a reply to message #315366] Mon, 21 April 2008 05:35 Go to previous message
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
how can i get .

You can get what you want by doing the following
a) Reading the forum guidelines
b) Also by using the search facility in this forum.



Previous Topic: Statement with sum(Col1+Col2) in where clause
Next Topic: rows missing for a date
Goto Forum:

Current Time: Fri Jul 21 16:31:33 CDT 2017

Total time taken to generate the page: 0.49412 seconds