Apache Derby DB Error Code 42X24 – Column is referenced in the HAVING clause but i

Posted by AbundantCode

In this blog post, let’s learn about the error message “42X24- Column is referenced in the HAVING clause but i” in Apache Derby Database and the description of the error.

Error Message

42X24- Column is referenced in the HAVING clause but i

Error Details

Column is referenced in the HAVING clause but is not in the GROUP BY list.