The complete list of Aggregate Functions in Snowflake are as follows. Aggregate function or aggregation function is a function where the values of multiple rows are grouped together to form a single summary value.

**General**

ANY_VALUE , AVG , CORR , COUNT , COUNT_IF, COVAR_POP , COVAR_SAMP , HASH_AGG , LISTAGG , MAX , MEDIAN , MIN , MODE , PERCENTILE_CONT , PERCENTILE_DISC , STDDEV / STDDEV_POP , STDDEV_SAMP , SUM , VAR_POP / VARIANCE_POP , VAR_SAMP / VARIANCE_SAMP / VARIANCE

**Order-sensitive (Window Functions)**

CUME_DIST , DENSE_RANK , FIRST_VALUE , LAG , LAST_VALUE , LEAD , NTH_VALUE , NTILE , PERCENT_RANK , RANK , ROW_NUMBER , WIDTH_BUCKET

**Bitwise**

BITAND_AGG , BITOR_AGG , BITXOR_AGG

**Boolean**

BOOLAND_AGG , BOOLOR_AGG , BOOLXOR_AGG

**Hash**

HASH_AGG

**Semi-structured Data**

ARRAY_AGG , OBJECT_AGG

**Linear Regression**

REGR_AVGX , REGR_AVGY , REGR_COUNT , REGR_INTERCEPT , REGR_R2 , REGR_SLOPE , REGR_SXX , REGR_SXY , REGR_SYY

**Statistics and Probability**

KURTOSIS , SKEW

**Cardinality Estimation**

APPROX_COUNT_DISTINCT , HLL , HLL_ACCUMULATE , HLL_COMBINE , HLL_ESTIMATE , HLL_EXPORT , HLL_IMPORT

**Similarity Estimation**

APPROXIMATE_JACCARD_INDEX , APPROXIMATE_SIMILARITY , MINHASH , MINHASH_COMBINE

**Frequency Estimation**

APPROX_TOP_K , APPROX_TOP_K_ACCUMULATE , APPROX_TOP_K_COMBINE , APPROX_TOP_K_ESTIMATE

**Percentile Estimation**

APPROX_PERCENTILE , APPROX_PERCENTILE_ACCUMULATE , APPROX_PERCENTILE_COMBINE , APPROX_PERCENTILE_ESTIMATE

**Aggregation Utilities**

GROUPING , GROUPING_ID