Knowledge Hub — Technical Document

Generated on 2026-08-28 07:02 | Confidential Client Asset

GROUP BY and HAVING in MySQL

Published July 26, 2025 By Sai Sree Ram Gundepudi

GROUP BY

SELECT department, COUNT(*) FROM employees GROUP BY department;

HAVING

SELECT department, COUNT(*) AS total 
FROM employees
GROUP BY department
HAVING total > 5;

Was this solution helpful?

Your feedback helps improve our technical knowledge repository.

Share this article

You may also like

GROUP BY and HAVING

GROUP BY and HAVING

GROUP BY and HAVINGGROUP BYSELECT department_id, AVG(salary) AS avg_salary FROM employees GROUP BY department_id;HAVINGS...