Eine Einführung in

SQL

Error 1111 Invalid use of group function

MySQL

Problem

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.

Solutions

  • Put the condition into the HAVING clause, after the GROUP BY clause.
  • SELECT winner FROM nobel
      GROUP BY winner
      HAVING COUNT(winner)>1


Specific to MySQL
In MySQL on LINUX the table names are case sensitive. This means that the table bbc exists but Bbc gives an error. This is a deviation from the SQL standard.