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 (A-C)

 

Composite ORDER BY not allowed with RANGE

Error constant SQLE_ILLEGAL_COMPOSITE_ORDERBY
ODBC 2 State ERROR
ODBC 3 State ERROR
Severity 16
SQLCODE –966
SQLSTATE 42WAA
Sybase error code 13524
Probable cause

Window functions that use the RANGE keyword may only ORDER BY a single column.