> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sdf.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Aggregate Functions

## `any_value`

Returns the first non-null value of a column
*Supported Signatures*

```sql theme={null}
function any_value($1) returns $1
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/any_value)

## `approx_count_distinct`

approximate distinct row count
*Supported Signatures*

```sql theme={null}
function approx_count_distinct($1, ...) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approx_count_distinct)

## `approx_percentile`

percentile approximation of inputs
*Supported Signatures*

```sql theme={null}
function approx_percentile(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approx_percentile)

## `approx_percentile_accumulate`

tdigest state in JSON format
*Supported Signatures*

```sql theme={null}
function approx_percentile_accumulate(double) returns object
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approx_percentile_accumulate)

## `approx_percentile_combine`

A tdigest state in JSON format
*Supported Signatures*

```sql theme={null}
function approx_percentile_combine(object) returns object
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approx_percentile_combine)

## `approx_percentile_estimate`

ESTIMATED PERCENTILE VALUE
*Supported Signatures*

```sql theme={null}
function approx_percentile_estimate(object, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approx_percentile_estimate)

## `approx_top_k`

Array containing top k items and their frequencies
*Supported Signatures*

```sql theme={null}
function approx_top_k($1) returns array
function approx_top_k($1, decimal(38, 0)) returns array
function approx_top_k($1, decimal(38, 0), decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approx_top_k)

## `approx_top_k_accumulate`

An internal state
*Supported Signatures*

```sql theme={null}
function approx_top_k_accumulate($1, decimal(38, 0)) returns object
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approx_top_k_accumulate)

## `approx_top_k_combine`

A state created by combining information from combining  all input
*Supported Signatures*

```sql theme={null}
function approx_top_k_combine(object) returns object
function approx_top_k_combine(object, decimal(38, 0)) returns object
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approx_top_k_combine)

## `approx_top_k_estimate`

Array containing most common k items and their frequencies
*Supported Signatures*

```sql theme={null}
function approx_top_k_estimate(object) returns array
function approx_top_k_estimate(object, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approx_top_k_estimate)

## `approximate_jaccard_index`

Similarity approximation of inputs
*Supported Signatures*

```sql theme={null}
function approximate_jaccard_index(variant) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approximate_jaccard_index)

## `approximate_similarity`

Similarity approximation of inputs
*Supported Signatures*

```sql theme={null}
function approximate_similarity(variant) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/approximate_similarity)

## `array_agg`

output array
*Supported Signatures*

```sql theme={null}
function array_agg($1) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/array_agg)

## `array_union_agg`

output array
*Supported Signatures*

```sql theme={null}
function array_union_agg(array) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/array_union_agg)

## `array_unique_agg`

output array
*Supported Signatures*

```sql theme={null}
function array_unique_agg($1) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/array_unique_agg)

## `avg`

Returns the average of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function avg(decimal(38, 0)) returns decimal(38, 0)
function avg(double) returns double
function avg(string) returns string
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/avg)

## `bitand_agg`

Returns the bitwise AND of a column. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function bitand_agg(decimal(38, 0)) returns decimal(38, 0)
function bitand_agg(string) returns string
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/bitand_agg)

## `bitmap_bit_position`

relative position in bitmap
*Supported Signatures*

```sql theme={null}
function bitmap_bit_position(decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/bitmap_bit_position)

## `bitmap_bucket_number`

bucket index of the destination bitmap
*Supported Signatures*

```sql theme={null}
function bitmap_bucket_number(decimal(38, 0)) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/bitmap_bucket_number)

## `bitmap_construct_agg`

bitmap
*Supported Signatures*

```sql theme={null}
function bitmap_construct_agg(decimal(38, 0)) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/bitmap_construct_agg)

## `bitmap_count`

number of set bits in the bitmap
*Supported Signatures*

```sql theme={null}
function bitmap_count(binary) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/bitmap_count)

## `bitmap_or_agg`

destination bitmap
*Supported Signatures*

```sql theme={null}
function bitmap_or_agg(binary) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/bitmap_or_agg)

## `bitor_agg`

Returns the bitwise OR of a column. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function bitor_agg(decimal(38, 0)) returns decimal(38, 0)
function bitor_agg(string) returns string
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/bitor_agg)

## `bitxor_agg`

Returns the bitwise XOR of a column. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function bitxor_agg(decimal(38, 0)) returns decimal(38, 0)
function bitxor_agg(string) returns string
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/bitxor_agg)

## `booland_agg`

Returns the logical (boolean) AND of a column. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function booland_agg(decimal(38, 0)) returns boolean
function booland_agg(boolean) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/booland_agg)

## `boolor_agg`

Returns the logical (boolean) OR of a column. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function boolor_agg(decimal(38, 0)) returns boolean
function boolor_agg(boolean) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/boolor_agg)

## `boolxor_agg`

Returns the logical (boolean) XOR of a column. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function boolxor_agg(decimal(38, 0)) returns boolean
function boolxor_agg(boolean) returns boolean
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/boolxor_agg)

## `corr`

Returns the correlation coefficient for non-null pairs in a group.
*Supported Signatures*

```sql theme={null}
function corr(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/corr)

## `count`

Return number of non-null values of a given expression
*Supported Signatures*

```sql theme={null}
function count(...) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/count)

## `count_if`

Returns a conditional count
*Supported Signatures*

```sql theme={null}
function count_if(boolean) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/count_if)

## `covar_pop`

Returns the population covariance for non-null pairs in a group.
*Supported Signatures*

```sql theme={null}
function covar_pop(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/covar_pop)

## `covar_samp`

Returns the sample covariance for non-null pairs in a group.
*Supported Signatures*

```sql theme={null}
function covar_samp(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/covar_samp)

## `grouping`

*Supported Signatures*

```sql theme={null}
function grouping(...) returns int
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/grouping)

## `grouping_id`

Returns grouping bit-vector
*Supported Signatures*

```sql theme={null}
function grouping_id($1, ...) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/grouping_id)

## `hash_agg`

aggregate hash value
*Supported Signatures*

```sql theme={null}
function hash_agg(...) returns decimal(19, 0)
function hash_agg($1) returns decimal(38, 0)
function hash_agg($1, $2) returns decimal(38, 0)
function hash_agg($1, $2, $3) returns decimal(38, 0)
function hash_agg($1, $2, $3, $4) returns decimal(38, 0)
function hash_agg($1, $2, $3, $4, $5) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hash_agg)

## `hll`

approximate distinct row count
*Supported Signatures*

```sql theme={null}
function hll($1, ...) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hll)

## `hll_accumulate`

HyperLogLog state
*Supported Signatures*

```sql theme={null}
function hll_accumulate($1, ...) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hll_accumulate)

## `hll_combine`

combined HyperLogLog state
*Supported Signatures*

```sql theme={null}
function hll_combine(binary) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hll_combine)

## `hll_estimate`

approximate distinct row count
*Supported Signatures*

```sql theme={null}
function hll_estimate(binary) returns decimal(38, 0)
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hll_estimate)

## `hll_export`

HyperLogLog state as a compound OBJECT
*Supported Signatures*

```sql theme={null}
function hll_export(binary) returns object
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hll_export)

## `hll_import`

HyperLogLog state in binary format
*Supported Signatures*

```sql theme={null}
function hll_import(object) returns binary
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/hll_import)

## `kurtosis`

Returns the sample kurtosis of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function kurtosis(decimal(38, 0)) returns double
function kurtosis(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/kurtosis)

## `listagg`

output string
*Supported Signatures*

```sql theme={null}
function listagg(varchar) returns varchar
function listagg(varchar, varchar) returns varchar
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/listagg)

## `max`

Returns the maximum of a column
*Supported Signatures*

```sql theme={null}
function max($1) returns $1
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/max)

## `max_by`

Returns value of first column with maximum second column val
*Supported Signatures*

```sql theme={null}
function max_by($1, $2) returns $1
function max_by($1, $2, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/max_by)

## `median`

The median of a column
*Supported Signatures*

```sql theme={null}
function median(decimal(p, s)) returns decimal(rp, rs)
function median(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/median)

## `min`

Returns the minimum of a column
*Supported Signatures*

```sql theme={null}
function min($1) returns $1
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/min)

## `min_by`

Returns value of first column with minimum second column val
*Supported Signatures*

```sql theme={null}
function min_by($1, $2) returns $1
function min_by($1, $2, decimal(38, 0)) returns array
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/min_by)

## `minhash`

Minhash state including an array of k (first input arg) minimum hash values
*Supported Signatures*

```sql theme={null}
function minhash(decimal(38, 0), $1, ...) returns variant
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/minhash)

## `minhash_combine`

Combined result of two (or more) minhash states
*Supported Signatures*

```sql theme={null}
function minhash_combine(variant) returns variant
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/minhash_combine)

## `mode`

Returns the most frequent item of a column
*Supported Signatures*

```sql theme={null}
function mode($1) returns $1
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/mode)

## `object_agg`

output object
*Supported Signatures*

```sql theme={null}
function object_agg(varchar, variant) returns object
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/object_agg)

## `percentile_cont`

value of a sorted key at specified percentile in continuous distribution
*Supported Signatures*

```sql theme={null}
function percentile_cont(decimal(p,s), $1) returns $1
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/percentile_cont)

## `percentile_disc`

value of a sorted key at specified percentile in discrete distribution
*Supported Signatures*

```sql theme={null}
function percentile_disc(decimal(p,s), $1) returns $1
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/percentile_disc)

## `regr_avgx`

Returns the average of the independent variable (2nd parameter) for non-null pairs.
*Supported Signatures*

```sql theme={null}
function regr_avgx(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regr_avgx)

## `regr_avgy`

Returns the average of the dependent variable (1st parameter) for non-null pairs.
*Supported Signatures*

```sql theme={null}
function regr_avgy(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regr_avgy)

## `regr_count`

Returns the number of non-null number pairs.
*Supported Signatures*

```sql theme={null}
function regr_count(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regr_count)

## `regr_intercept`

Returns the intercept of the univariate linear regression line for non-null pairs.
*Supported Signatures*

```sql theme={null}
function regr_intercept(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regr_intercept)

## `regr_r2`

Returns the coefficient of determination for non-null pairs.
*Supported Signatures*

```sql theme={null}
function regr_r2(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regr_r2)

## `regr_slope`

Returns the slope of the linear regression line for non-null pairs.
*Supported Signatures*

```sql theme={null}
function regr_slope(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regr_slope)

## `regr_sxx`

Returns REGR\_COUNT(expr1, expr2) \* VAR\_POP(expr2) for non-null pairs.
*Supported Signatures*

```sql theme={null}
function regr_sxx(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regr_sxx)

## `regr_sxy`

Returns REGR\_COUNT(expr1, expr2) \* COVAR\_POP(expr1, expr2) for non-null pairs.
*Supported Signatures*

```sql theme={null}
function regr_sxy(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regr_sxy)

## `regr_syy`

Returns REGR\_COUNT(expr1, expr2) \* VAR\_POP(expr1) for non-null pairs.
*Supported Signatures*

```sql theme={null}
function regr_syy(double, double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/regr_syy)

## `skew`

Returns the sample skew of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function skew(decimal(38, 0)) returns double
function skew(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/skew)

## `stddev`

Returns the sample standard deviation of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function stddev(decimal(38, 0)) returns double
function stddev(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/stddev)

## `stddev_pop`

Returns the population standard deviation of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function stddev_pop(decimal(38, 0)) returns double
function stddev_pop(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/stddev_pop)

## `stddev_samp`

Returns the sample standard deviation of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function stddev_samp(decimal(38, 0)) returns double
function stddev_samp(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/stddev_samp)

## `sum`

Returns a sum of a column
*Supported Signatures*

```sql theme={null}
function sum(decimal(p, s)) returns decimal(rp, s)
function sum(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/sum)

## `var_pop`

Returns the population variance of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function var_pop(decimal(38, 0)) returns double
function var_pop(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/var_pop)

## `var_samp`

Returns the sample variance of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function var_samp(decimal(38, 0)) returns double
function var_samp(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/var_samp)

## `variance`

Returns the sample variance of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function variance(decimal(38, 0)) returns double
function variance(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/variance)

## `variance_pop`

Returns the population variance of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function variance_pop(decimal(38, 0)) returns double
function variance_pop(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/variance_pop)

## `variance_samp`

Returns the sample variance of the values in a group. Null values are ignored.
*Supported Signatures*

```sql theme={null}
function variance_samp(decimal(38, 0)) returns double
function variance_samp(double) returns double
```

[🔗 Official Documentation](https://docs.snowflake.com/en/sql-reference/functions/variance_samp)