Home » SQL & PL/SQL » SQL & PL/SQL » How to get missing values
How to get missing values [message #219891] Fri, 16 February 2007 10:11 Go to next message
rajesh4851
Messages: 89
Registered: January 2007
Member
Hi,
I want to find out the missing numbers from a group of numbers(it may be sequence numbers).
Example.
I have numbers 1,3,6,7,8,9 ok.
the missing numbers are 2,4,5 from the above group.
Now i want to find out those missing numbers using sql query.
Means result should be 2,4,5.

Thanks & Regards,
Rajesh
Re: How to get missing values [message #219893 is a reply to message #219891] Fri, 16 February 2007 10:15 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Did a simple search on this forum
and found
Re: How to get missing values [message #219896 is a reply to message #219893] Fri, 16 February 2007 10:23 Go to previous message
rajesh4851
Messages: 89
Registered: January 2007
Member
Thanks it is working.
Previous Topic: Data Migration Problem
Next Topic: Converting Dates
Goto Forum:
  


Current Time: Thu Dec 08 12:07:38 CST 2016

Total time taken to generate the page: 0.27515 seconds