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:
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|