SQL Order By Count

by

You need to aggregate the data first, this can be done using the GROUP BY clause:

SELECT Group, COUNT(*)
FROM table
GROUP BY Group
ORDER BY COUNT(*) DESC

The DESC keyword allows you to show the highest count first, ORDER BY by default orders in ascending order which would show the lowest count first.

More Related Contents:

  1. Which DB technology is sued to solve the following search issue? [closed]
  2. MyISAM versus InnoDB [closed]
  3. Compare two MySQL databases [closed]
  4. How should I resolve –secure-file-priv in MySQL?
  5. How do I quickly rename a MySQL database (change schema name)?
  6. What does character set and collation mean exactly?
  7. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  8. Storing image in database directly or as base64 data?
  9. Implementation of Levenshtein distance for mysql/fuzzy search?
  10. Does MySQL index foreign key columns automatically?
  11. What’s the difference between MyISAM and InnoDB? [duplicate]
  12. GROUP_CONCAT ORDER BY
  13. Is there an ANSI SQL alternative to the MYSQL LIMIT keyword?
  14. In SQL, is it OK for two tables to refer to each other?
  15. Hyphens in column names in MySQL DB
  16. Error Code: 1215. Cannot add foreign key constraint (foreign keys)
  17. Modeling Product Variants
  18. How to increase MySQL connections(max_connections)?
  19. MySql views performance [closed]
  20. Using reserved words in column names
  21. Proper database model for a user feedback system (an interesting case)
  22. MySQL – Replace Character in Columns
  23. Sort the rows according to the order specified in WHERE IN clause
  24. FIND_IN_SET with multiple value [duplicate]
  25. What is the difference between SQL and MySQL? [closed]
  26. mysql Failed to read auto-increment value from storage engine
  27. How to Get True Size of MySQL Database?
  28. MySQL: Computed Column
  29. mysql order by, null first, and DESC after
  30. How do I make a MySQL database run completely in memory?

Leave a Comment