Order by COUNT per value

by 
SELECT count(City), City
FROM table
GROUP BY City
ORDER BY count(City);

OR

SELECT count(City) as count, City
FROM table
GROUP BY City
ORDER BY count;

Ahh, sorry, I was misinterpreting your question. I believe Peter Langs answer was the correct one.

More Related Contents:

  1. Complex Count in MySQL
  2. How does MySQL process ORDER BY and LIMIT in a query?
  3. Ordering by the order of values in a SQL IN() clause
  4. Ordering by specific field value first
  5. MySQL “Group By” and “Order By”
  6. Using union and order by clause in mysql
  7. SQL order string as number
  8. Most efficient way to get table row count
  9. MySQL order by “best match”
  10. MySQL/MariaDB – order by inside subquery
  11. How to get the count of each distinct value in a column? [duplicate]
  12. Mysql: Order by like?
  13. Sort the rows according to the order specified in WHERE IN clause
  14. ORDER BY alphabet first then follow by number
  15. MYSQL Select One Random record from each Category
  16. i have an error which i dont understand. can you help me? [closed]
  17. In SQL Server how to get the count of child if both parent and child are available [closed]
  18. MySQL select 10 random rows from 600K rows fast
  19. Get a list of dates between two dates
  20. Calculate a running total in MySQL
  21. Simulate lag function in MySQL
  22. Get record counts for all tables in MySQL database
  23. How do I check if a column is empty or null in MySQL?
  24. Use MySQL spatial extensions to select points inside circle
  25. INSERT … ON DUPLICATE KEY (do nothing)
  26. MySQL create stored procedure syntax with delimiter
  27. Deleting duplicate rows from a table
  28. MySQL LIKE query with underscore
  29. Compare only day and month with date field in mysql
  30. Update multiple rows with multiple ‘where’ clauses for each individual row

Leave a Comment