ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function
An aggregate (SUM, COUNT, AVG) was used in WHERE, which filters rows before grouping.
Seen on:
SQL
Meaning
WHERE runs before GROUP BY; aggregates must be filtered with HAVING (or in an outer query).
Common causes
- WHERE SUM(x) > …
- Aggregates in UPDATE SET without a subquery
⚡ Quick fix
- Move the condition to HAVING
- Use a subquery/CTE for complex filters
Detailed fix by platform
SQL
SELECT customer_id, SUM(total) FROM orders GROUP BY customer_id HAVING SUM(total) > 1000;
How to diagnose
- Clause — Aggregate in WHERE?
- Recent change — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.
🧠 Still stuck? Analyze your error
Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.
Was this page helpful?
Report a correction or suggest an improvement
Last updated 2 Oct 2026