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: table with sparce data

Re: table with sparce data

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Fri, 22 Aug 2003 11:37:24 -0700
Message-ID: <Nxt1b.19$3j7.147@news.oracle.com>


"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

... Received on Fri Aug 22 2003 - 13:37:24 CDT

Original text of this message

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