since you're grouping on product you don't need to include it in the count 
statement. this just leaves distinct customers.
select productid, count(distinct customerid) as total from ownership group 
by productid

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/nhusers/-/HqSbMfRtvl4J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to