Error 962

"Argument to GROUPING aggregate must be a grouping column in the GROUP BY clause"

Item Description

SQLCode

-962L

Constant

INVALID_GROUPING_AGGREGATE

SQLState

42WA7

ODBC 2 State

37000

ODBC 3 State

42000

Sybase Error Code

2626

Severity Code

15

Probable cause

Only a grouping column is permitted as an argument to the GROUPING aggregate function. An argument that contains anything other than a single grouping column expression will not be accepted.


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com