This reference table describes the aggregation functions you can use with WorkSpace Data Federation’s Aggregate and Group By operators.
| Function | Description |
|---|---|
| Sum | Adds the value of this column’s expression for each row to obtain a total. |
| Average | Averages the values of expression for each row—equivalent to using Sum and dividing by Count. |
| Maximum | Returns the highest value of expression from the input result set. |
| Minimum | Returns the lowest value of expression from the input result set. |
| Count | Returns the number of rows in the input result set. The value of expression is ignored. This function returns an integer regardless of the type of the expression. |
| First | Returns the value of expression for the first row in the input result set. |
| Last | Returns the value of expression for the last row in the input result set. |
| Population variance | Returns the population variance for the values of expression in the input result set. |
| Sample variance | Returns the sample variance for the values of expression in the input result set. |
| Population standard deviation | Returns the population standard deviation for the values of expression in the input result set. |
| Sample standard deviation | Returns the sample standard deviation for the values of expression in the input result set. |
Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com
Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.