Complete list of Aggregate Functions in snowflake

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

Author: user

Leave a Reply

Your email address will not be published. Required fields are marked *