Aggregate functions

GoogleSQL for Bigtable supports the following general aggregate functions. To learn about the syntax for aggregate function calls, see Aggregate function calls.

Function list

Name	Summary
ANY_VALUE	Gets an expression for some row.
APPROX_COUNT_DISTINCT	Gets the approximate result for COUNT(DISTINCT expression). For more information, see Approximate aggregate functions.
APPROX_QUANTILES	Gets the approximate quantile boundaries. For more information, see Approximate aggregate functions.
APPROX_TOP_COUNT	Gets the approximate top elements and their approximate count. For more information, see Approximate aggregate functions.
APPROX_TOP_SUM	Gets the approximate top elements and sum, based on the approximate sum of an assigned weight. For more information, see Approximate aggregate functions.
ARRAY_AGG	Gets an array of values.
ARRAY_CONCAT_AGG	Concatenates arrays and returns a single array as a result.
AVG	Gets the average of non-NULL values.
BIT_AND	Performs a bitwise AND operation on an expression.
BIT_OR	Performs a bitwise OR operation on an expression.
BIT_XOR	Performs a bitwise XOR operation on an expression.
CORR	Computes the Pearson coefficient of correlation of a set of number pairs. For more information, see Statistical aggregate functions.
COUNT	Gets the number of rows in the input, or the number of rows with an expression evaluated to any value other than NULL.
COUNTIF	Gets the number of TRUE values for an expression.
COVAR_POP	Computes the population covariance of a set of number pairs. For more information, see Statistical aggregate functions.
COVAR_SAMP	Computes the sample covariance of a set of number pairs. For more information, see Statistical aggregate functions.
LOGICAL_AND	Gets the logical AND of all non-NULL expressions.
LOGICAL_OR	Gets the logical OR of all non-NULL expressions.
MAX	Gets the maximum non-NULL value.
MIN	Gets the minimum non-NULL value.
PERCENTILE_CONT	Computes the specified percentile for a value, using linear interpolation. For more information, see Navigation functions.
PERCENTILE_DISC	Computes the specified percentile for a discrete value. For more information, see Navigation functions.
ST_EXTENT	Gets the bounding box for a group of GEOGRAPHY values. For more information, see Geography functions.
ST_UNION_AGG	Aggregates over GEOGRAPHY values and gets their point set union. For more information, see Geography functions.
STDDEV	An alias of the STDDEV_SAMP function. For more information, see Statistical aggregate functions.
STDDEV_POP	Computes the population (biased) standard deviation of the values. For more information, see Statistical aggregate functions.
STDDEV_SAMP	Computes the sample (unbiased) standard deviation of the values. For more information, see Statistical aggregate functions.
STRING_AGG	Concatenates non-NULL STRING or BYTES values.
SUM	Gets the sum of non-NULL values.
VAR_POP	Computes the population (biased) variance of the values. For more information, see Statistical aggregate functions.