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
RAY_HT
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
pablolee
Messages: 2834
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.
Re: how to find missing numbers [message #315372 is a reply to message #315366] Mon, 21 April 2008 05:35 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Quote:
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.

http://www.orafaq.com/forum/m/287940/94420/?srch=missing+numbers#msg_287940

Regards

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


Current Time: Wed Dec 07 12:42:58 CST 2016

Total time taken to generate the page: 0.24684 seconds