Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: table with sparce data
"Mikito Harakiri" <mikharakiri_at_ywho.com> wrote in message
news:9vt1b.18$3j7.31_at_news.oracle.com...
> I have data like this
>
> Name Value
> ---- ------
> a001 0
> a002 0
> a003 0
> a004 0
> a005 2
> a006 0
> a007 0
> a010 0
> a011 3
> a017 0
> ...
>
> and I want a report where sparcely populated frequency is compressed like
> this
>
> Min Value Frequency
> Name
> ---- ------ -----------
> a001 0 4
> a023 5 1
> a006 0 3
> a011 3 1
> ...
>
> Any simple analytical solution?
2 typos! The corrected output:
and I want a report where sparcely populated value column is compressed like this
Min Value Frequency
Name
---- ------ -----------
a001 0 4 a005 5 1 a006 0 3 a011 3 1