Using Windows in a FROM Clause
CCL windows are typically defined by the use of a KEEP clause. This section explains how to define basic windows by adding a KEEP clause to the FROM clause of your query.
See the Sybase CEP CCL Reference for complete KEEP clause syntax.
- Defining Count-Based Windows
Count-based windows have a KEEP clause that defines the maximum number of rows the window keeps, and whether or not these rows or buckets expire from the window one at a time, or all in a group.
- Defining Time-Based Windows
Time-based windows have a KEEP clause that defines how long the window will keep rows, and whether or not these rows will expire from the window one at a time, or all in a group.
Created March 8, 2010. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com