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.
For the purposes of explanation in this chapter, the window aggregate functions are broken up into 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:
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|