"Window function requires ORDER BY"
| Item |
Description |
|
SQLCode
|
-965L
|
|
Constant
|
OBSOLETE_ORDERBY_REQUIRED
|
|
SQLState
|
42WA9
|
|
ODBC 2 State
|
ERROR
|
|
ODBC 3 State
|
ERROR
|
|
Sybase Error Code
|
2629
|
|
Severity Code
|
16
|
Probable cause
Rank functions and window functions that use the RANGE keyword must specify an ORDER BY clause.