Code: Select all
id | customer_id | product_id
---+-------------+------------
1 | 5 | 33
2 | 8 | 57
3 | 2 | 41
4 | 5 | 38
5 | 3 | 19
6 | 8 | 84
7 | 6 | 52
8 | 8 | 60Code: Select all
SELECT customer_id FROM Orders GROUP BY customer_id HAVING COUNT(*)>1Question: how do I select only the number of customers that have more than one order?
Changing the query from SELECT customer_id into SELECT COUNT(customer_id) or SELECT COUNT(*) results in the number of orders per customer_id, but I just want it to return one value (in the above example that would be 2, because only customer_ids 5 and 8 have more than one order).