mysql count number of occurrences in a column

Solutions on MaxInterview for mysql count number of occurrences in a column by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "mysql count number of occurrences in a column"
Alix
26 Aug 2018
1SELECT name,COUNT(*) 
2FROM tablename 
3GROUP BY name 
4ORDER BY COUNT(*) DESC;