Aggregation Functions
Function | Description | Examples |
|---|---|---|
AVG | Calculates the average of the values from the selected column. | Display the average hours worked for a department. |
COLLECT | Takes a database column and creates a nested table from the selected rows; associates a list of data with a specific value, enabling aggregation of data into a collection. | Create a list of employees within a department. |
COUNT | Lists the number of rows returned from the database for the selected column. | Determine the number of employee records returned from a database query. |
MAX | Returns the maximum value of the selected column's values. | Display the maximum hours worked. |
MIN | Returns the minimum value of the selected column's values. | Display the minimum hours worked. |
STDDEV | Returns the standard deviation of the selected column's values. | Apply standard deviation to values, for example, for forecasting. |
SUM | Calculates the sum of the values from the selected column. | Display the total hours worked for a department. |