SQL Count number of occurrences for each distinct combination

Question

I need to get the count for each distinct combination of two columns. Here is the query to get the distinct combinations.

SELECT distinct Sales_Cat, Sub_cat
FROM rtx_Sales

It returns all combinations as seen below. I need to add a count field that also shows the number of occurrences for each of the combinations. Is SQL capable of this or should I write a python script to query for each combo?

I think follow an SQL course, and find out what GROUP BY can do .... see: learn.microsoft.com/en-us/sql/t-sql/queries/… — Luuk
– Luuk, Commented Oct 20, 2022 at 19:21
select sales_cat, sub_cat, count('Dracula') as cnt from rtx_sales group by sales_cat, sub_cat — Bryan Dellinger
– Bryan Dellinger, Commented Oct 20, 2022 at 19:21
been a few years since I have touched sql so yes I do need a refresher lol - thank you though — Justin Wade
– Justin Wade, Commented Oct 20, 2022 at 19:23

laur · Accepted Answer · 2022-10-20 19:38:50Z

1

Use COUNT()

SELECT sales_cat, sub_cat, COUNT(*)
FROM rtx_sales 
GROUP BY sales_cat, sub_cat

answered Oct 20, 2022 at 19:38

laur

5001 gold badge9 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Count number of occurrences for each distinct combination

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related