Website logo
⌘K
🏠Homepage
👋Introduction
Key Concepts & Architecture
🚀Run Oxla in 2 minutes
🏃‍♂️Run Oxla on S3
🛫Multi-node Deployment
👨‍💻SQL Reference
SQL Queries
SQL Clauses
SQL Data Types
SQL Functions
Schema
Comment Support
⛓️SQL Mutations
DELETE
UPDATE
🚨Error Handling
🆚Differences Between Oxla vs. PostgreSQL
🔄Understanding Transactions
📈Public Metrics
⚙️Oxla Configuration File
✨Changelog
Docs powered by Archbee
SQL Reference
SQL Functions

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.

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.



Updated 09 Oct 2023
Did this page help you?
PREVIOUS
POWER
NEXT
SUM
Docs powered by Archbee
Docs powered by Archbee

©2023 Oxla