DB2 SQL-Error: -119

Short Description: A COLUMN IDENTIFIED IN A HAVING CLAUSE IS NOT INCLUDED IN THE GROUP BY CLAUSE C E SQL S T P R C DB SQL R HAVING GROUP BY

A column identified in a HAVING clause (possibly within a scalar function) does not appear in the GROUP BY clause. Columns specified in a HAVING clause must appear within aggregate functions or also be specified in the GROUP BY clause. Grouping expressions can be used in a search condition in a HAVING clause. A grouping expression specifies only one value for each group. A grouping expression specified in this context must exactly match a grouping expression specified in the GROUP BY clause, except that blanks are not significant.

 <-  BACK TO INDEX