SQL query select count from table

Question

i have a table like :

id_cat  id_city 
1   33
1   33
1   33
2   44
2   33
2   55

and i want to obtain a result like :

id_cat id_city cat_count 
1      33      3  
2      44      1
2      33      1
2      55      1

how can i build my query ? Thanks!

John Woo · Accepted Answer · 2013-02-26 09:47:07Z

2

Use COUNT() which is an aggregate function and a GROUP BY clause.

SELECT  id_cat, id_city, COUNT(*) cat_Count
FROM    tableName 
GROUP   BY id_cat, id_city

answered Feb 26, 2013 at 9:47

John Woo

265k70 gold badges509 silver badges500 bronze badges

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

1 Answer 1