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.