This would probably best be solved procedurally. If you can come up with a query that does it, it will probably be very ugly. Also, what result would you expect in this case:
1 2 5 7 8 12 ?? Mike On Sat, Sep 5, 2009 at 6:49 AM, Dave Hart <[email protected]> wrote: > > Hi, > I have a table which includes data like this: > > SEQ > 1 > 2 > 3 > 4 > 8 > 9 > 10 > 11 > 12 > 13 > 20 > 21 > 22 > 23 > 24 > > I want to be able to write a query that displays the upper and lower > bounds of each range: > LBound UBound > 1 4 > 8 13 > 20 24 > > I've found plenty of queries that find the start and end of the gaps > but none that display the start and end of the ranges. > > Any help is appreciated. > > Thanks, > Dave > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
