mysql count number of occurrences in a column

WanderingAlbatross

Code: SQL

2021-06-25 17:20:15

SELECT name,COUNT(*) 
FROM tablename 
GROUP BY name 
ORDER BY COUNT(*) DESC;

New to Communities?

Join the community