Difference between revisions of "Invalid Group function"
|Line 37:||Line 37:|
Latest revision as of 14:20, 9 August 2012
We want to filter the results returned based on an aggregate function such as COUNT or SUM.
The WHERE clause may not be used for this. The WHERE conditions are considered before the aggregation.
- Put the condition into the HAVING clause, after the GROUP BY clause.
SELECT winner FROM nobel GROUP BY winner HAVING COUNT(winner)>1
SELECT winner FROM nobel WHERE COUNT(winner)>1 GROUP BY winner
bbc exists but
Bbc gives an error.
This is a deviation from the SQL standard.