How to get the count of each distinct value in a column? [duplicate] May 7, 2023 by Tarik SELECT category, COUNT(*) AS `num` FROM posts GROUP BY category