Re: table with sparce data

Mikito Harakiri wrote:

> "Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message
> news:Nxt1b.19$3j7.147_at_news.oracle.com...
> > Min Value Frequency
> > Name
> > ---- ------ -----------
> > a001 0 4
> > a005 5 1
> > a006 0 3
> > a011 3 1
>
> Missed one more typo:
>
> Min Value Frequency
> Name
> ---- ------ -----------
> a001 0 4
> a005 2 1
> a006 0 3
> a011 3 1
>
> In other words we keep all rows with value > 0, and compress all the
> successive rows with value = 0 showing aggregated frequency.

We get the idea. ;-)

This would be best done with a cursor loop. One problem any oslutoin will have is determining your sort order. You know what you want. But a program may not.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)