Re: table with sparce data

TurkBear wrote:

> "Mikito Harakiri" <mikharakiri_at_ywho.com> 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.
> >
> >
> Still not sure what you want, but try:
>
> select name,value,count(*) from table
> group by name,value;

Don't think that's what he wants. He seems to want the program to lump zero values into the preceding entry that had a value. An analytic function might do the job but it would be more trouble than it would be worth. If I understand the OP's thing I could write the code in 7 minutes.

--
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)