Can I do this with SQL

[Mondeo]

I have an SQL table with a column called Town, it looks something like this

 

Burnley

Burnley

Burnley

Blackburn

Preston

Colne

Colne

Preston

Blackburn

 

I need to get the counts of each town in the database so I want my results to look like this

 

Burnley 3

Blackburn 2

Preston 2

Colne 2

 

Is there anyway I can do it just using a plain SQL statement?

 

Thanks

[dinoboy]

Yes, this can be done with COUNT() function and GROUP BY statement

 

SELECT COUNT(name) AS count, name FROM table GROUP BY name 

 

Where 'table' is name of the table and column 'name' is the name of the column you use.