Count the occurrences of DISTINCT values

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

More Related Contents:

  1. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  2. Selecting distinct 2 columns combination in mysql
  3. Which DB technology is sued to solve the following search issue? [closed]
  4. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  5. How to select the nth row in a SQL database table?
  6. 1052: Column ‘id’ in field list is ambiguous
  7. How to do a batch insert in MySQL
  8. Storing JSON in database vs. having a new column for each key
  9. How do I restore a dump file from mysqldump?
  10. Cast int to varchar
  11. Check for x consecutive days – given timestamps in database
  12. MySQL Insert Into from one Database in another
  13. How do I get the ID of multiple inserted rows in MySQL?
  14. Import SQL file into mysql
  15. Does mysql have the equivalent of Oracle’s “analytic functions”?
  16. How to skip certain database tables with mysqldump?
  17. “where 1=1” statement [duplicate]
  18. How to set a MySQL row to READ-ONLY?
  19. MySQL: LAST_INSERT_ID() returns 0
  20. Remove special characters from a database field
  21. Using reserved words in column names
  22. Calculating a Moving Average MySQL?
  23. MySQL – Replace Character in Columns
  24. Strings as Primary Keys in MYSQL Database [closed]
  25. MySQL : ERROR 1215 (HY000): Cannot add foreign key constraint
  26. FIND_IN_SET with multiple value [duplicate]
  27. What is the difference between SQL and MySQL? [closed]
  28. How to store a one to many relation in MySQL database?
  29. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  30. MySQL: Computed Column

Leave a Comment