How to get the count of each distinct value in a column? [duplicate]

by 
SELECT
  category,
  COUNT(*) AS `num`
FROM
  posts
GROUP BY
  category

More Related Contents:

  1. Complex Count in MySQL
  2. Most efficient way to get table row count
  3. Order by COUNT per value
  4. multiple query same table but in different columns mysql
  5. How can I make SQL case sensitive string comparison on MySQL?
  6. 1052: Column ‘id’ in field list is ambiguous
  7. How to do a batch insert in MySQL
  8. Count the occurrences of DISTINCT values
  9. Creating a “Numbers Table” in MySQL
  10. Why does MySQL allow “group by” queries WITHOUT aggregate functions?
  11. Cumulative sum over a set of rows in mysql
  12. Set NOW() as Default Value for datetime datatype?
  13. Add Auto-Increment ID to existing table?
  14. MySQL SELECT DISTINCT multiple columns
  15. SQL DELETE with JOIN another table for WHERE condition
  16. mysql trigger stored trigger is already used by statement which invoked stored trigger
  17. MySQL error 1241: Operand should contain 1 column(s)
  18. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  19. Count with IF condition in MySQL query
  20. Mysql: Order by like?
  21. Getting first day of the week in MySql using Week No
  22. Is there a way to get the row number in Mysql like the rownum in oracle [duplicate]
  23. How to get a list of months between two dates in mysql
  24. How to format number with “.” as thousands separator and “,” as decimal separator?
  25. Using DISTINCT and COUNT together in a MySQL Query
  26. How to check if field is null or empty in MySQL?
  27. Strip last two characters of a column in MySQL
  28. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  29. What happens when I exhaust a bigint generated key? How to handle it?
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment