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

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Communication error Next Page

Composite ORDER BY not allowed with RANGE


Item

Value

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.