Error 964

"Window function used in predicate"

Item Description

SQLCode

-964L

Constant

ILLEGAL_WINDOW_PREDICATE

SQLState

42WA8

ODBC 2 State

ERROR

ODBC 3 State

ERROR

Sybase Error Code

2628

Severity Code

16

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.


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