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: eliminating gaps

Re: eliminating gaps

From: Dieter Noeth <dnoeth_at_gmx.de>
Date: Thu, 31 Aug 2006 14:32:33 +0200
Message-ID: <ed6kto$535$1@online.de>


Dieter Noeth wrote:

> select
> a,
> min(b),
> max(b)
> from
> (
> select
> a - rank() over (partition by A order by b asc) as grp,
> a
> from mytab
> ) dt
> group by a, grp
> order by 1,2;

Sorry, of course it's:

select

   a,
   min(b),
   max(b)
from
  (
   select

     b - rank() over (partition by A order by b asc) grp,
     a,
     b

   from mytab
  ) dt
group by a, grp
order by 1,2;

Dieter Received on Thu Aug 31 2006 - 07:32:33 CDT

Original text of this message

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