Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Select grouping ranges of records

Re: Select grouping ranges of records

From: Frank <fbortel_at_nescape.net>
Date: Sat, 29 Nov 2003 16:05:36 +0100
Message-ID: <bqac43$22m$1@news2.tilbu1.nb.home.nl>


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 ?

Yes - and so does your instructor
It's in the books, somewhere.

-- 
Regards, Frank van Bortel
Received on Sat Nov 29 2003 - 09:05:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US