DB2 Error Code – -119 a column identified in a having clause is not included in the group by clause

In this post, you’ll learn about the error message -119 a column identified in a having clause is not included in the group by clause in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-119 a column identified in a having clause is not included in the group by clause

Reason for the Error

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 column functions or also be specified in the GROUP BY clause.

Solution

The implied function is not supported by DB2.