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 |
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.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |