Window aggregate functions return a value for a specified set of rows in the input. For example, you can use window functions to calculate a moving average of the sales figures for a company over a specified time period.
Window aggregate functions are organized into the following three categories:
Basic aggregate functions Following is the list of supported basic aggregate functions:
For more information about basic aggregate functions, see Basic aggregate functions.
Standard deviation and variance functions Following is the list of supported standard deviation and variance functions:
For more information about standard deviation and variance functions, see Standard deviation and variance functions.
Correlation and linear regression functions Following is the list of supported correlation and linear regression functions:
For more information about correlation and linear regression functions, see Correlation and linear regression functions.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |