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:
Standard deviation and variance functions Following is the list of supported standard deviation and variance functions:
Correlation and linear regression functions Following is the list of supported correlation and linear regression functions:
See also |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |