Aggregation Functions

1min

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.
﻿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. 
﻿

Updated 11 May 2023

Did this page help you?

Yes

SIN

SUM

Docs powered by archbee

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.
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.