Re: Calculating unique sums

From: <steveee_ca_at_my-deja.com>
Date: Wed, 29 Nov 2000 13:46:09 GMT
Message-ID: <9031av$r9m$1@nnrp1.deja.com>

Hi,
I hope I have your question right..you show a 'count' field in your example, so I'm thinking you want to count the number of different customers that had a transaction involving a product?

Try this..

SELECT PRODUCTID,COUNT(DISTINCT CUSTOMER_ID) FROM TRANSACTIONS
GROUP BY PRODUCTID; I hope this does it for you.

Steve

In article <3A2415EC.4B55861A_at_weinerfamily.org>, sw_at_weinerfamily.org wrote:
> I have a transaction table: transaction_id,product_id,customer_id.
> I want to get list of UNIQUE customers (not # of transactions) that
> purchased each product.
> The result may look something like this:
> Product Customer Count
> A 500
> B 23
> C 175
>
> Does anyone have advice on the most efficient way to do this? I am
> dealing with hundreds of millions of transactions.
>
> Thanks
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 29 2000 - 07:46:09 CST