0

Is there a way to do a DISTINCT on more than one col, say, customer_id and market, and then COUNT customer_id in the same statem

Table has two columns - Customer ID - Market Output Req: Unique list of Customer ID and Market. Then finally check if there are more than one record for a customer ID

27th Aug 2017, 3:28 PM
Saurabh
1 Odpowiedź
0
SELECT market, COUNT(DISTINCT customer_id)... Group by market
27th Aug 2017, 3:38 PM
Alyson Jorge
Alyson Jorge - avatar