SQL Group By with an Order By

by

In all versions of MySQL, simply alias the aggregate in the SELECT list, and order by the alias:

SELECT COUNT(id) AS theCount, `Tag` from `images-tags`
GROUP BY `Tag`
ORDER BY theCount DESC
LIMIT 20

More Related Contents:

  1. MySQL: Invalid use of group function
  2. get first occurrence of last changed value of a column [closed]
  3. MySQL – Rows to Columns
  4. ROW_NUMBER() in MySQL
  5. multiple query same table but in different columns mysql
  6. How can I make SQL case sensitive string comparison on MySQL?
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. How to do a batch insert in MySQL
  9. Count the occurrences of DISTINCT values
  10. MySQL offset infinite rows
  11. Ordering by the order of values in a SQL IN() clause
  12. Creating a “Numbers Table” in MySQL
  13. SQL Selecting from two Tables with inner join and limit [duplicate]
  14. MySQL Group by SUM
  15. In SQL, how to select the top 2 rows for each group
  16. Mysql query to dynamically convert rows to columns on the basis of two columns
  17. mysql trigger stored trigger is already used by statement which invoked stored trigger
  18. How to skip certain database tables with mysqldump?
  19. MySQL error 1241: Operand should contain 1 column(s)
  20. How to set a MySQL row to READ-ONLY?
  21. How to create dummy variable columns for thousands of categories in Google BigQuery?
  22. Mysql: Order by like?
  23. Most efficient way to store IP Address in MySQL [duplicate]
  24. Getting first day of the week in MySql using Week No
  25. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  26. MySQL OPTIMIZE all tables?
  27. Strip last two characters of a column in MySQL
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. Deleting a row based on the max value

Leave a Comment