Windows
A window is a stateful element that can be named or unnamed, and retains rows based on a defined retention policy.
- Named Windows
A named window is explicitly created using a CREATE WINDOW statement, and can be referenced in other queries.
- Unnamed Windows
An unnamed window is an implicitly created stateful element that cannot be referenced or used elsewhere in a project.
- Retention
A retention policy specifies the maximum number of rows or the maximum period of time that data are retained in a window.
Created April 23, 2012. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com