In this blog post, let’s learn about the error message “42Y29- The SELECT list of a non-grouped query contains at least one” in Apache Derby Database and the description of the error.
Error Message
42Y29- The SELECT list of a non-grouped query contains at least one
Error Details
The SELECT list of a non-grouped query contains at least one invalid expression. When the SELECT list contains at least one aggregate then all entries must be valid aggregate expressions.