Aggregation Functions
Overview
Aggregation Functions
Overview
Aggregate functions compute a single result from a set of input values. Oxla supports the following functions:
| Functions | Description |
|---|---|
| SUM | Calculates and returns the sum of all values. |
| MIN | Calculates and returns the minimum value. |
| FOR_MIN | Calculates and returns a value corresponding to the minimal metric in the same row from a set of values. |
| MAX | Calculates and returns the maximum value. |
| FOR_MAX | Calculates and Returns a value corresponding to the maximum metric in the same row from a set of values. |
| AVG | Calculates and returns the average value. |
| COUNT | Counts the number of rows. |
| BOOL_AND | Calculates the boolean of all the boolean values in the aggregated group. FALSE if at least one of aggregated rows is FALSE |
| BOOL_OR | Calculates the boolean of all the boolean values in the aggregated group. TRUE if at least one of aggregated rows is TRUE. |
| Function qualifiers | Description |
|---|---|
| DISTINCT | Allows aggregation functions to operate on a distinct set of values within a column. |
You can utilize the aggregate functions with the
GROUP BY and HAVING clauses in the SELECT statement.