Aggregation Functions
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. |
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. |
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. |
Calculates the boolean of all the boolean values in the aggregated group. FALSE if at least one of aggregated rows is FALSE | |
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.