count top 10 most occuring values in a column in mysql

by 
SELECT col, count(*)
    FROM tablethingie
    GROUP BY col
    ORDER BY count(*) DESC
    LIMIT 10

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. How can I make SQL case sensitive string comparison on MySQL?
  3. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  4. Count the occurrences of DISTINCT values
  5. Codeigniter – multiple database connections
  6. Column count doesn’t match value count at row 1
  7. How to search JSON data in MySQL?
  8. MySQL > Table doesn’t exist. But it does (or it should)
  9. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  10. How do I modify a MySQL column to allow NULL?
  11. Connect to mysql in a docker container from the host
  12. Set NOW() as Default Value for datetime datatype?
  13. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  14. SQL DELETE with JOIN another table for WHERE condition
  15. How to connect to a MySQL Data Source in Visual Studio
  16. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  17. MySQL: #1075 – Incorrect table definition; autoincrement vs another key?
  18. mysql update query with sub query
  19. How can I implement single table inheritance using Laravel’s Eloquent?
  20. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  21. Integrity constraint violation: 1452 Cannot add or update a child row:
  22. How to change the mysql root password
  23. How can I set autoincrement format to 0001 in MySQL?
  24. Why MYSQL IN keyword not considering NULL values
  25. MySQL. Can’t create table errno 150
  26. What’s mysql’s “BETWEEN” performance over..?
  27. MySQL: set field default value to other column
  28. CREATE command denied to user？
  29. Deleting a row based on the max value
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment