Functions that allow you to perform analytic operations over a set of input rows are referred to as window functions. For
example, all ranking functions, and most aggregate functions, are **window functions**. You can use them to perform additional analysis on your data. This is achieved by partitioning and sorting the input rows,
prior to their being processed, and then processing the rows in a configurable-sized window that moves through the input.

There are three types of window functions: window aggregate functions, window ranking functions, and row numbering functions.

Window aggregate functions

Basic aggregate functions

Standard deviation and variance functions

Correlation and linear regression functions

Window ranking functions

Row numbering functions

Envoyer votre avis sur cette page par email. | Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |