website logo
⌘K
🏠Homepage
👋Introduction
Key Concepts & Architecture
🚀Getting Started
👨‍💻SQL Reference
SQL Queries
SQL Clauses
SQL Data Types
SQL Functions
Schema
🚨Error Handling
🆚Differences Between Oxla vs. PostgreSQL
Docs powered by archbee 

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
No
PREVIOUS
SIN
NEXT
SUM
Docs powered by archbee 

Dedicated to data analytics that provides 10x faster execution of analytical queries than current state of the art solutions. We are launching SOON! Join the waiting list for more info.




©2022 Oxla