Error 966

"Composite ORDER BY not allowed with RANGE"

Item Description

SQLCode

-966L

Constant

ILLEGAL_COMPOSITE_ORDERBY

SQLState

42WAA

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

2630

Severity Code

16

Probable cause

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


Created May 6, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com