Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (A-C)

 

Constant expressions must not appear in GROUP BY clause

Error constant SQLE_NO_CONSTANTS_IN_GROUP_BY
ODBC 2 State 37000
ODBC 3 State 42000
Severity 15
SQLCODE –928
SQLSTATE 42W9D
Sybase error code 13557
Probable cause

You used a constant in the GROUP BY clause. Constants must not appear in the GROUP BY clause for a query. References to columns in a view that are constant are permitted in a GROUP BY clause. Also, expressions that use a view column that is constant are permitted.