Re: COUNT(DISTINCT) on summarized data

From: Stacy White <harsh_at_computer.org>
Date: Sun, 22 Feb 2004 22:05:53 GMT
Message-ID: <5J9_b.368483$I06.3862875@attbi_s01>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1077484195.211004_at_yasure...
> Stacy White wrote:
> > But I can't add a 'unique_customers' field, and 'SELECT
> > SUM(unique_customers)' since that would count some customers twice.
> >
> > ...
> > Any suggestions?
>
> What you are describing is not relational ... it is OLAP. If you
> have 9i use the built-in OLAP capabilities.

Thanks, Daniel. I'll look into OLAP in more detail. Received on Sun Feb 22 2004 - 16:05:53 CST