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

Window function requires ORDER BY Next Page

Window function used in predicate

Item

Value

Constant

SQLE_ILLEGAL_WINDOW_PREDICATE

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Severity

16

SQLCODE

-964

SQLSTATE

42WA8

Sybase error code

13526

Probable cause

A window function was used in the WHERE or HAVING clause of a SELECT statement. Consider making the SELECT into a derived table, putting the window function in the select list of the derived table, and changing the predicate to reference the derived column.