Apache Derby DB Error Code 42Y36 – Column reference ‘‘ is invalid. For a SELECT list

Posted by AbundantCode

In this blog post, let’s learn about the error message “42Y36- Column reference ‘‘ is invalid. For a SELECT list” in Apache Derby Database and the description of the error.

Error Message

42Y36- Column reference ‘‘ is invalid. For a SELECT list

Error Details

Column reference ‘‘ is invalid. For a SELECT list with a GROUP BY, the list may only contain valid grouping expressions and valid aggregate expressions.