Select a range of number and group them in Oracle

Vote count:

0

I have a table called Numbers in the below format:

Number Extension 
123     1
123     24
123     6
123     10
123     11
123     25
123     2
123     3
123     13

I need a result set like this:

Number Begin End
123     1     3
123     6     6
123     10    13
123     24    25

There are several numbers and each number has these extension in random order. I need to group them in the range for each number such that those extensions are existing.

Let me know for any questions/clarifications.

asked 44 secs ago

user1455116

368

Select a range of number and group them in Oracle