Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Queries and data modification » OLAP support » Window functions


Window definition: Inlining using the OVER clause and WINDOW clause

There are three ways to define a window:

  • inline (within the OVER clause of a window function)

  • in a WINDOW clause

  • partially inline and partially in a WINDOW clause

However, some approaches have restrictions, as noted in the following sections.

 Inline definition (within the OVER clause of a window function)
 WINDOW clause definition
 Combination inline and WINDOW clause definition
 See also