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. |
MAX() | Calculates and returns the maximum value. |
AVG() | Calculates and returns the average value. |
COUNT() | Counts the number of rows. |
ABS() | Calculates and returns the absolute value. |
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.