Re: Select grouping ranges of records

From: lsouzaf <lsouzaf_at_yahoo.com>
Date: 30 Nov 2003 01:11:55 -0800
Message-ID: <38bbe165.0311300111.5b58cf@posting.google.com>

First of all ! Thank you Daniel and Frank. This is not home work., it´s a real situation and I have to do it fast. Someone told that it was really simple but I couldn't find the solution quickly so I decided to ask.

Sorry for the inconvenient!

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1070123040.992927_at_yasure>...
> lsouzaf wrote:
>
> > I´m designing a new report and I have a query that returns something like :
> >
> > 1,2,3,4,5,9,10,11,15,16,17,20,24,25.
> >
> > I need to print this result like this:
> >
> > From 1 to 5
> > From 9 to 11
> > From 15 to 17
> > 20
> > From 24 to 25
> >
> > Does anyone have an idea of how can this be done ?
>
> We do not do homework but we will provide hints. So here's yours:
>
> There is a function, similar in usage to DECODE, that works with ranges.
> Where were you when it was discussed in class? You can find it if you go
> to http://tahiti.oracle.com and search for DECODE and then in the same
> on-line book put in some effort.
Received on Sun Nov 30 2003 - 03:11:55 CST