Messages associated with SQLSTATE 42803

This topic lists the messages associated with the SQLSTATE 42803.

SQLSTATE 42803 description

GROUPING_ERROR

Messages associated with this SQLState

ERROR 2134: Aggregate function calls in subqueries cannot refer to
            columns in parent (outer) query
ERROR 2135: Aggregate function calls may not be nested
ERROR 2140: Aggregates not allowed in GROUP BY clause
ERROR 2141: Aggregates not allowed in JOIN conditions
ERROR 2142: Aggregates not allowed in WHERE clause
ERROR 2219: Argument string must not contain aggregates
ERROR 2543: Cannot use aggregate function in EXECUTE parameter
ERROR 2544: Cannot use aggregate function in function expression in
            FROM
ERROR 2640: Column "string.string" must appear in the GROUP BY clause or be
            used in an aggregate function
ERROR 4300: ORDER/GROUP BY expression not found in targetlist
ERROR 4634: Rule WHERE condition may not contain aggregate functions
ERROR 4667: SEGMENTED BY expression may not contain aggregate
            functions
ERROR 4841: Subquery uses ungrouped column "string.string" from outer query
ERROR 6139: All non-aggregate expressions in the projection SELECT
            list must appear in the GROUP BY clause
ERROR 6187: Cannot use aggregate expressions in the projection SELECT
            list without a GROUP BY clause
ERROR 6277: Grouping functions not allowed in GROUP BY clause
ERROR 6278: Grouping functions not allowed in JOIN conditions
ERROR 6279: Grouping functions not allowed in WHERE clause
ERROR 7085: Aggregate function calls cannot contain grouping functions
ERROR 7099: Grouping functions cannot be nested
ERROR 7182: Grouping function arguments need to be group by
            expressions