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 . |
You can utilize the aggregate functions with the
GROUP BY
and HAVING
clauses in the SELECT
statement.