babyshandy
7/14/2016 - 4:03 PM

How to use count and group by at the same select statement http://stackoverflow.com/questions/2722408/how-to-use-count-and-group-by-at-the-s

How to use count and group by at the same select statement http://stackoverflow.com/questions/2722408/how-to-use-count-and-group-by-at-the-same-select-statement

count-group-by.sql
content_copyfile_download
SELECT town, COUNT(town) 
FROM user
GROUP BY town


-- Town         Count
-- Copenhagen   58
-- NewYork      58
-- Athens       58