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