readthefuckingmanual.net

[SOLVED] ERROR: aggregates not allowed in WHERE clause

Error added: 2006-04-28T12:46:40Z

1 people waiting for the answer...

1 answers found.

You have to use it in a HAVING clause.

Instead of SELECT * FROM foo WHERE AVG(bar) > 0

use

SELECT * FROM foo HAVING AVG(bar) > 0

Add an answer/solution

If you know the answer, please add your own solution below.
If you don't know, but find out later, please come back and share your answer - there will be other people struggling with this too.

If you want to be notified via email when this is solved, enter your email address here: