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

SQL Anywhere 11.0.1 » Error Messages » SQL Anywhere error messages » SQL Anywhere error messages sorted by message text (D-K)

 

Illegal ORDER BY in aggregate function

Error constant SQLE_INVALID_ORDERBY_IN_AGGREGATE
ODBC 2 State 37000
ODBC 3 State 42000
Severity 15
SQLCODE –904
SQLSTATE 42W90
Sybase error code 13579
Probable cause

An ORDER BY can be used in an aggregate function only if there are no DISTINCT aggregates in the select list, or there is a single DISTINCT aggregate with the DISTINCT column equal to the first column of the ORDER BY. Also, multiple ordered aggregates cannot be used in the same select list unless they have the exact same ORDER BY clause.