Description\n-----------\n\nstored-aggregate-functions.md\n\nStored 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.\n\navg.md\n\nCalculate the average value. This function computes the arithmetic mean of a numeric expression, ignoring NULL values.\n\nbit_and.md\n\nPerform a bitwise AND operation. This function returns the result of performing a bitwise AND on all values in a given expression.\n\nbit_or.md\n\nPerform a bitwise OR operation. This function returns the result of performing a bitwise OR on all values in a given expression.\n\nbit_xor.md\n\nPerform a bitwise XOR operation. This function returns the result of performing a bitwise XOR on all values in a given expression.\n\ncount-distinct.md\n\nCount unique values. This function returns the number of distinct, non-NULL values found in the specified column or expression.\n\ncount.md\n\nComplete COUNT() function reference: COUNT(*) and COUNT(expr) syntax, COUNT(DISTINCT) usage, GROUP BY aggregation, and OVER(PARTITION BY) window syntax.\n\ngroup_concat.md\n\nComplete GROUP_CONCAT reference for MariaDB. Complete function guide with syntax, parameters, return values, and usage examples for production use.\n\njson_arrayagg.md\n\nAggregate values into a JSON array. This function aggregates a result set column into a single JSON array.\n\njson_objectagg.md\n\nAggregate key-value pairs into a JSON object. This function aggregates two columns or expressions into a single JSON object.\n\nmax.md\n\nFind the maximum value. This function returns the highest value in a set of values, applicable to numbers, strings, and dates.\n\nmin.md\n\nFind the minimum value. This function returns the lowest value in a set of values, applicable to numbers, strings, and dates.\n\nstd.md\n\nCalculate population standard deviation. This function returns the square root of the population variance. It is a synonym for STDDEV_POP().\n\nstddev.md\n\nCalculate population standard deviation. This function is a synonym for STD() and STDDEV_POP(), returning the square root of the population variance.\n\nstddev_pop.md\n\nCalculate population standard deviation. This function computes the standard deviation assuming the set of values represents the entire population.\n\nstddev_samp.md\n\nCalculate sample standard deviation. This function computes the standard deviation assuming the set of values represents a sample of the population.\n\nsum.md\n\nCalculate the total sum. This function returns the sum of all values in a numeric expression, ignoring NULL values.\n\nvar_pop.md\n\nCalculate population variance. This function computes the statistical variance for a set of values assumed to be the entire population.\n\nvar_samp.md\n\nCalculate sample variance. This function computes the statistical variance for a set of values assumed to be a sample of the population.\n\nvariance.md\n\nCalculate population variance. This function is a synonym for VAR_POP() and returns the variance of a set of values.\n\nURL: https://mariadb.com/docs/server/reference/sql-functions/aggregate-functions/README