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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Querying and modifying data » 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