rory oconnor <[EMAIL PROTECTED]> writes:
[...]
> each item in a cart is a record, so simply querying on records won't
> work. What I need to count is how many distinct customerId's there
> are. a sample from the table looks like:
>
> cartItemIdcustomerId productId
> 1944 244
I'm trying to write a query that will tell me how many abandoned carts
there are in a "cart" table I have.
each item in a cart is a record, so simply querying on records won't
work. What I need to count is how many distinct customerId's there
are. a sample from the table looks like:
cartItemId