Aggregate Functions

Perform calculations on multiple rows to return a single value. Includes standard SQL functions like SUM, AVG, COUNT, MIN, and MAX, often used with GROUP BY.

Stored Aggregate Functions

Stored Aggregate Functions allow users to create custom aggregate functions that process a sequence of rows and return a single summary result. This page provides a general overview.

AVG

Calculate the average value. This function computes the arithmetic mean of a numeric expression, ignoring NULL values.

BIT_AND

Perform a bitwise AND operation. This function returns the result of performing a bitwise AND on all values in a given expression.

BIT_OR

Perform a bitwise OR operation. This function returns the result of performing a bitwise OR on all values in a given expression.

BIT_XOR

Perform a bitwise XOR operation. This function returns the result of performing a bitwise XOR on all values in a given expression.

COUNT DISTINCT

Count unique values. This function returns the number of distinct, non-NULL values found in the specified column or expression.

COUNT

Complete COUNT() function reference: COUNT(*) and COUNT(expr) syntax, COUNT(DISTINCT) usage, GROUP BY aggregation, and OVER(PARTITION BY) window syntax.

GROUP_CONCAT

Complete GROUP_CONCAT reference for MariaDB. Complete function guide with syntax, parameters, return values, and usage examples for production use.

JSON_ARRAYAGG

Aggregate values into a JSON array. This function aggregates a result set column into a single JSON array.

JSON_OBJECTAGG

Aggregate key-value pairs into a JSON object. This function aggregates two columns or expressions into a single JSON object.

MAX

Find the maximum value. This function returns the highest value in a set of values, applicable to numbers, strings, and dates.

MIN

Find the minimum value. This function returns the lowest value in a set of values, applicable to numbers, strings, and dates.

STD

Calculate population standard deviation. This function returns the square root of the population variance. It is a synonym for STDDEV_POP().

STDDEV

Calculate population standard deviation. This function is a synonym for STD() and STDDEV_POP(), returning the square root of the population variance.

STDDEV_POP

Calculate population standard deviation. This function computes the standard deviation assuming the set of values represents the entire population.

STDDEV_SAMP

Calculate sample standard deviation. This function computes the standard deviation assuming the set of values represents a sample of the population.

SUM

Calculate the total sum. This function returns the sum of all values in a numeric expression, ignoring NULL values.

VAR_POP

Calculate population variance. This function computes the statistical variance for a set of values assumed to be the entire population.

VAR_SAMP

Calculate sample variance. This function computes the statistical variance for a set of values assumed to be a sample of the population.

VARIANCE

Calculate population variance. This function is a synonym for VAR_POP() and returns the variance of a set of values.