Re: table with sparce data

"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. Received on Fri Aug 22 2003 - 13:41:28 CDT