Aggregate Function Reference 

Standard aggregate functions:

• count
• min
• max
• sum
• avg
• any
• stddevPop
• stddevSamp
• varPop
• varSamp
• covarPop
• covarSamp

ClickHouse-specific aggregate functions:

• anyHeavy

• anyLast

• argMin

• argMax

• avgWeighted

• topK

• topKWeighted

• groupArray

• groupUniqArray

• groupArrayInsertAt

• groupArrayMovingAvg

• groupArrayMovingSum

• groupBitAnd

• groupBitOr

• groupBitXor

• groupBitmap

• groupBitmapAnd

• groupBitmapOr

• groupBitmapXor

• sumWithOverflow

• sumMap

• minMap

• maxMap

• skewSamp

• skewPop

• kurtSamp

• kurtPop

• timeSeriesGroupSum

• timeSeriesGroupRateSum

• uniq

• uniqExact

• uniqCombined

• uniqCombined64

• uniqHLL12

• quantile

• quantiles

• quantileExact

• quantileExactWeighted

• quantileTiming

• quantileTimingWeighted

• quantileDeterministic

• quantileTDigest

• quantileTDigestWeighted

• simpleLinearRegression

• stochasticLinearRegression

• stochasticLogisticRegression

• categoricalInformationValue