SELECT 
customer_id, 
product_id, COUNT(*) 
FROM cust_table GROUP BY 
customer_id, 
product_id  HAVING (COUNT(*) > 1) 
Conservative.  Idaho.  Software engineer.  Historian.  Trying to prevent Idiocracy from becoming a documentary.
 
Email complaints/requests about copyright infringement to clayton @ claytoncramer.com.  Reminder: the last copyright troll that bothered me went bankrupt.
No comments:
Post a Comment