MySQL SQL

MySQL HAVING

Filter groups after aggregation.

SELECT category, COUNT(*) AS product_count
FROM products
GROUP BY category
HAVING COUNT(*) > 5;

Use WHERE for rows before grouping and HAVING for grouped results.