Relational Data - Aggregate Functions - Reference
Standard aggregate functions:
- count
- min
- max
- sum
- avg
- any
- stddevPop
- stddevPopStable
- stddevSamp
- stddevSampStable
- varPop
- varSamp
- corr
- corr
- corrMatrix
- covarPop
- covarStable
- covarPopMatrix
- covarSamp
- covarSampStable
- covarSampMatrix
- entropy
- exponentialMovingAverage
- intervalLengthSum
- kolmogorovSmirnovTest
- mannwhitneyutest
- median
- rankCorr
- sumKahan
- studentTTest
- welchTTest
ClickHouse-specific aggregate functions:
- aggThrow
- analysisOfVariance
- any
- anyHeavy
- anyLast
- boundingRatio
- first_value
- last_value
- argMin
- argMax
- avgWeighted
- topK
- topKWeighted
- deltaSum
- deltaSumTimestamp
- flameGraph
- groupArray
- groupArrayLast
- groupUniqArray
- groupArrayInsertAt
- groupArrayMovingAvg
- groupArrayMovingSum
- groupArraySample
- groupArraySorted
- groupArrayIntersect
- groupBitAnd
- groupBitOr
- groupBitXor
- groupBitmap
- groupBitmapAnd
- groupBitmapOr
- groupBitmapXor
- sumWithOverflow
- sumMap
- sumMapWithOverflow
- sumMapFiltered
- sumMapFilteredWithOverflow
- minMap
- maxMap
- skewSamp
- skewPop
- kurtSamp
- kurtPop
- uniq
- uniqExact
- uniqCombined
- uniqCombined64
- uniqHLL12
- uniqTheta
- quantile
- quantiles
- quantileExact
- quantileExactLow
- quantileExactHigh
- quantileExactWeighted
- quantileTiming
- quantileTimingWeighted
- quantileDeterministic
- quantileTDigest
- quantileTDigestWeighted
- quantileBFloat16
- quantileBFloat16Weighted
- quantileDD
- simpleLinearRegression
- singleValueOrNull
- stochasticLinearRegression
- stochasticLogisticRegression
- categoricalInformationValue
- contingency
- cramersV
- cramersVBiasCorrected
- theilsU
- maxIntersections
- maxIntersectionsPosition
- meanZTest
- quantileGK
- quantileInterpolatedWeighted
- sparkBar
- sumCount
- largestTriangleThreeBuckets