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 -~----------~----~----~----~------~----~------~--~---
