🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 89 (from laksa188)

2. Crawled Status Check

Query:

curl -X POST \
  'http://laksa089.int.ahrefs:8124/' \
  -H 'Content-Type: text/plain' \
  -H 'X-ClickHouse-Database: crawler3' \
  -H 'Authorization: Basic YXBpOg==' \
  -d 'SELECT getAhrefsURLFromUnparsed(src_unparsed) AS found_url, ifNull(toUnixTimestamp(download_stamp), 0) AS crawl_time, ifNull(toUnixTimestamp(props_url_first_seen), 0) AS first_indexed_time, download_http_code AS http_code, src_unparsed AS src_unparsed, src_root_hash AS src_root_hash, history_drop_reason AS history_drop_reason, meta_title AS meta_title, meta_descriptions AS meta_descriptions, attrs_boilerpipe_text AS attrs_boilerpipe_text, attrs_markdown AS attrs_markdown, attrs_readable_markdown AS attrs_readable_markdown, meta_canonical AS meta_canonical FROM crawler3.page_info_local FINAL PREWHERE (src_root_hash, src_unparsed) IN ((getAhrefsRootHashFromUnparsed(getAhrefsUnparsedNoserviceFromURL(\'https://clickhouse.com/docs/sql-reference/aggregate-functions/reference\')), getAhrefsUnparsedNoserviceFromURL(\'https://clickhouse.com/docs/sql-reference/aggregate-functions/reference\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference","crawl_time":1775246983,"first_indexed_time":1740108217,"http_code":200,"src_unparsed":"com,clickhouse!\/docs\/sql-reference\/aggregate-functions\/reference s443","src_root_hash":"12633450985039531489","history_drop_reason":null,"meta_title":"Aggregate Functions | ClickHouse Docs","meta_descriptions":["Landing page for aggregate functions with complete list of aggregate functions"],"attrs_boilerpipe_text":"aggThrow\nThis function can be used for the purpose of testing exception safety. It will throw an exception on creation with the specified probability.\nanalysisOfVariance\nProvides a statistical test for one-way analysis of variance (ANOVA test). It is a test over several groups of normally distributed observations to find out whether all groups have the same mean or not.\nany\nSelects the first encountered value of a column.\nanyHeavy\nSelects a frequently occurring value using the heavy hitters algorithm. If there is a value that occurs more than in half the cases in each of the query execution threads, this value is returned. Normally, the result is nondeterministic.\nanyLast\nSelects the last encountered value of a column.\napprox_top_k\nReturns an array of the approximately most frequent values and their counts in the specified column.\napprox_top_sum\nReturns an array of the approximately most frequent values and their counts in the specified column.\nargAndMax\nCalculates the\narg\nand\nval\nvalue for a maximum\nval\nvalue. If there are multiple rows with equal\nval\nbeing the maximum, which of the associated\narg\nand\nval\nis returned is not deterministic.\nargAndMin\nCalculates the\narg\nand\nval\nvalue for a minimum\nval\nvalue. If there are multiple rows with equal\nval\nbeing the minimum, which of the associated\narg\nand\nval\nis returned is not deterministic.\nargMax\nCalculates the\narg\nvalue for a maximum\nval\nvalue.\nargMin\nCalculates the\narg\nvalue for a minimum\nval\nvalue. If there are multiple rows with equal\nval\nbeing the maximum, which of the associated\narg\nis returned is not deterministic.\navg\nCalculates the arithmetic mean.\navgWeighted\nCalculates the weighted arithmetic mean.\nboundingRatio\nAggregate function that calculates the slope between the leftmost and rightmost points across a group of values.\ncategoricalInformationValue\nCalculates the value of\n(P(tag = 1) - P(tag = 0))(log(P(tag = 1)) - log(P(tag = 0)))\nfor each category.\ncontingency\nThe\ncontingency\nfunction calculates the contingency coefficient, a value that measures the association between two columns in a table. The computation is similar to the\ncramersV\nfunction but with a different denominator in the square root.\ncorr\nCalculates the Pearson correlation coefficient.\ncorrMatrix\nComputes the correlation matrix over N variables.\ncorrStable\nCalculates the Pearson correlation coefficient, but uses a numerically stable algorithm.\ncount\nCounts the number of rows or not-NULL values.\ncovarPop\nCalculates the population covariance\ncovarPopMatrix\nReturns the population covariance matrix over N variables.\ncovarPopStable\nCalculates the value of the population covariance\ncovarSamp\nCalculates the value of\nΣ((x - x̅)(y - y̅)) \/ (n - 1)\ncovarSampMatrix\nReturns the sample covariance matrix over N variables.\ncovarSampStable\nSimilar to covarSamp but works slower while providing a lower computational error.\ncramersV\nThe result of the\ncramersV\nfunction ranges from 0 (corresponding to no association between the variables) to 1 and can reach 1 only when each value is completely determined by the other. It may be viewed as the association between two variables as a percentage of their maximum possible variation.\ncramersVBiasCorrected\nCalculates Cramer's V, but uses a bias correction.\ndeltaSum\nSums the arithmetic difference between consecutive rows.\ndeltaSumTimestamp\nAdds the difference between consecutive rows. If the difference is negative, it is ignored.\ndistinctDynamicTypes\nCalculates the list of distinct data types stored in Dynamic column.\ndistinctJSONPaths\nCalculates a list of distinct paths stored in a JSON column.\ndistinctJSONPathsAndTypes\nCalculates the list of distinct paths and their types stored in JSON\nentropy\nCalculates Shannon entropy of for a column of values.\nestimateCompressionRatio\nEstimates the compression ratio of a given column without compressing it.\nexponentialMovingAverage\nCalculates the exponential moving average of values for the determined time.\nexponentialTimeDecayedAvg\nReturns the exponentially smoothed weighted moving average of values of a time series at point\nt\nin time.\nexponentialTimeDecayedCount\nReturns the cumulative exponential decay over a time series at the index\nt\nin time.\nexponentialTimeDecayedMax\nReturns the maximum of the computed exponentially smoothed moving average at index\nt\nin time with that at\nt-1\n.\nexponentialTimeDecayedSum\nReturns the sum of exponentially smoothed moving average values of a time series at the index\nt\nin time.\nfirst_value\nIt is an alias for any but it was introduced for compatibility with Window Functions, where sometimes it is necessary to process\nNULL\nvalues (by default all ClickHouse aggregate functions ignore NULL values).\nflameGraph\nAggregate function which builds a flamegraph using the list of stacktraces.\ngroupArray\nCreates an array of argument values. Values can be added to the array in any (indeterminate) order.\ngroupArrayArray\nAggregates arrays into a larger array of those arrays.\ngroupArrayInsertAt\nInserts a value into the array at the specified position.\ngroupArrayIntersect\nReturn an intersection of given arrays (Return all items of arrays, that are in all given arrays).\ngroupArrayLast\nCreates an array of the last argument values.\ngroupArrayMovingAvg\nCalculates the moving average of input values.\ngroupArrayMovingSum\nCalculates the moving sum of input values.\ngroupArraySample\nCreates an array of sample argument values. The size of the resulting array is limited to\nmax_size\nelements. Argument values are selected and added to the array randomly.\ngroupArraySorted\nReturns an array with the first N items in ascending order.\ngroupBitAnd\nApplies bit-wise\nAND\nfor series of numbers.\ngroupBitmap\nBitmap or Aggregate calculations from a unsigned integer column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object\ngroupBitmapAnd\nCalculations the AND of a bitmap column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object.\ngroupBitmapOr\nCalculations the OR of a bitmap column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object. This is equivalent to\ngroupBitmapMerge\n.\ngroupBitmapXor\nCalculates the XOR of a bitmap column, and returns the cardinality of type UInt64, if used with suffix -State, then it returns a bitmap object\ngroupBitOr\nApplies bit-wise\nOR\nto a series of numbers.\ngroupBitXor\nApplies bit-wise\nXOR\nfor series of numbers.\ngroupConcat\nCalculates a concatenated string from a group of strings, optionally separated by a delimiter, and optionally limited by a maximum number of elements.\ngroupUniqArray\nCreates an array from different argument values.\nintervalLengthSum\nCalculates the total length of union of all ranges (segments on numeric axis).\nkolmogorovSmirnovTest\nApplies Kolmogorov-Smirnov's test to samples from two populations.\nkurtPop\nComputes the kurtosis of a sequence.\nkurtSamp\nComputes the sample kurtosis of a sequence.\nlargestTriangleThreeBuckets\nApplies the Largest-Triangle-Three-Buckets algorithm to the input data.\nlast_value\nSelects the last encountered value, similar to\nanyLast\n, but could accept NULL.\nmannWhitneyUTest\nApplies the Mann-Whitney rank test to samples from two populations.\nmax\nAggregate function that calculates the maximum across a group of values.\nmaxIntersections\nAggregate function that calculates the maximum number of times that a group of intervals intersects each other (if all the intervals intersect at least once).\nmaxIntersectionsPosition\nAggregate function that calculates the positions of the occurrences of the maxIntersections function.\nmaxMap\nCalculates the maximum from\nvalue\narray according to the keys specified in the\nkey\narray.\nmeanZTest\nApplies mean z-test to samples from two populations.\nmedian\nThe\nmedian*\nfunctions are the aliases for the corresponding\nquantile*\nfunctions. They calculate median of a numeric data sample.\nmin\nAggregate function that calculates the minimum across a group of values.\nminMap\nCalculates the minimum from\nvalue\narray according to the keys specified in the\nkey\narray.\nquantile\nComputes an approximate quantile of a numeric data sequence.\nquantileBFloat16\nComputes an approximate quantile of a sample consisting of bfloat16 numbers.\nquantileDD\nComputes an approximate quantile of a sample with relative-error guarantees.\nquantileDeterministic\nComputes an approximate quantile of a numeric data sequence.\nquantileExact Functions\nquantileExact, quantileExactLow, quantileExactHigh, quantileExactExclusive, quantileExactInclusive functions\nquantileExactExclusive\nExactly computes the quantile of a numeric data sequence.\nquantileExactHigh\nSimilar to quantileExact, this computes the exact quantile of a numeric data sequence.\nquantileExactInclusive\nExactly computes the quantile of a numeric data sequence.\nquantileExactLow\nSimilar to quantileExact, this computes the exact\nquantile\nof a numeric data sequence.\nquantileExactWeighted\nExactly computes the quantile of a numeric data sequence, taking into account the weight of each element.\nquantileExactWeightedInterpolated\nComputes quantile of a numeric data sequence using linear interpolation, taking into account the weight of each element.\nquantileGK\nComputes the quantile of a numeric data sequence using the Greenwald-Khanna algorithm.\nquantileInterpolatedWeighted\nComputes quantile of a numeric data sequence using linear interpolation, taking into account the weight of each element.\nquantilePrometheusHistogram\nComputes quantile of a histogram using linear interpolation.\nquantiles Functions\nquantiles, quantilesExactExclusive, quantilesExactInclusive, quantilesGK\nquantilesExactExclusive\nExactly computes the quantiles of a numeric data sequence.\nquantilesExactInclusive\nExactly computes the quantiles of a numeric data sequence.\nquantilesGK\nquantilesGK works similarly to quantileGK but allows us to calculate quantities at different levels simultaneously and returns an array.\nquantilesTimingWeighted\nWith the determined precision computes the quantile of a numeric data sequence according to the weight of each sequence member.\nquantileTDigest\nComputes an approximate quantile of a numeric data sequence using the t-digest algorithm.\nquantileTDigestWeighted\nComputes an approximate quantile of a numeric data sequence using the t-digest algorithm.\nquantileTiming\nWith the determined precision computes the quantile of a numeric data sequence.\nquantileTimingWeighted\nWith the determined precision computes the quantile of a numeric data sequence according to the weight of each sequence member.\nrankCorr\nComputes a rank correlation coefficient.\nsimpleLinearRegression\nPerforms simple (unidimensional) linear regression.\nsingleValueOrNull\nThe aggregate function\nsingleValueOrNull\nis used to implement subquery operators, such as\nx = ALL (SELECT ...)\n. It checks if there is only one unique non-NULL value in the data.\nskewPop\nComputes the skewness of a sequence.\nskewSamp\nComputes the sample skewness of a sequence.\nsparkbar\nThe function plots a frequency histogram for values\nx\nand the repetition rate\ny\nof these values over the interval\n[min_x, max_x]\n.\nstddevPop\nThe result is equal to the square root of varPop.\nstddevPopStable\nThe result is equal to the square root of varPop. Unlike stddevPop, this function uses a numerically stable algorithm.\nstddevSamp\nThe result is equal to the square root of varSamp\nstddevSampStable\nThe result is equal to the square root of varSamp. Unlike this function uses a numerically stable algorithm.\nstochasticLinearRegression\nThis function implements stochastic linear regression. It supports custom parameters for learning rate, L2 regularization coefficient, mini-batch size, and has a few methods for updating weights (Adam, simple SGD, Momentum, Nesterov.)\nstochasticLogisticRegression\nThis function implements stochastic logistic regression. It can be used for binary classification problem, supports the same custom parameters as stochasticLinearRegression and works the same way.\nstudentTTest\nApplies the student t-test to samples from two populations.\nstudentTTestOneSample\nApplies the one-sample Student t-test to a sample and a known population mean.\nsum\nCalculates the sum. Only works for numbers.\nsumCount\nCalculates the sum of the numbers and counts the number of rows at the same time. The function is used by ClickHouse query optimizer: if there are multiple\nsum\n,\ncount\nor\navg\nfunctions in a query, they can be replaced to single\nsumCount\nfunction to reuse the calculations. The function is rarely needed to use explicitly.\nsumKahan\nCalculates the sum of the numbers with Kahan compensated summation algorithm\nsumMap\nTotals one or more\nvalue\narrays according to the keys specified in the\nkey\narray. Returns a tuple of arrays: keys in sorted order, followed by values summed for the corresponding keys without overflow.\nsumMapWithOverflow\nTotals a\nvalue\narray according to the keys specified in the\nkey\narray. Returns a tuple of two arrays: keys in sorted order, and values summed for the corresponding keys. Differs from the sumMap function in that it does summation with overflow.\nsumWithOverflow\nComputes the sum of the numbers, using the same data type for the result as for the input parameters. If the sum exceeds the maximum value for this data type, it is calculated with overflow.\ntheilsU\nThe\ntheilsU\nfunction calculates Theils' U uncertainty coefficient, a value that measures the association between two columns in a table.\ntimeSeriesChangesToGrid\nAggregate function that calculates PromQL-like changes over time series data on the specified grid.\ntimeSeriesDeltaToGrid\nAggregate function that calculates PromQL-like delta over time series data on the specified grid.\ntimeSeriesDerivToGrid\nAggregate function that calculates PromQL-like derivative over time series data on the specified grid.\ntimeSeriesGroupArray\nSorts time series by timestamp in ascending order.\ntimeSeriesInstantDeltaToGrid\nAggregate function that calculates PromQL-like idelta over time series data on the specified grid.\ntimeSeriesInstantRateToGrid\nAggregate function that calculates PromQL-like irate over time series data on the specified grid.\ntimeSeriesLastTwoSamples\nAggregate function for re-sampling time series data for PromQL-like irate and idelta calculation\ntimeSeriesPredictLinearToGrid\nAggregate function that calculates PromQL-like linear prediction over time series data on the specified grid.\ntimeSeriesRateToGrid\nAggregate function that calculates PromQL-like rate over time series data on the specified grid.\ntimeSeriesResampleToGridWithStaleness\nAggregate function that re-samples time series data to the specified grid.\ntimeSeriesResetsToGrid\nAggregate function that calculates PromQL-like resets over time series data on the specified grid.\ntopK\nReturns an array of the approximately most frequent values in the specified column. The resulting array is sorted in descending order of approximate frequency of values (not by the values themselves).\ntopKWeighted\nReturns an array of the approximately most frequent values in the specified column. The resulting array is sorted in descending order of approximate frequency of values (not by the values themselves). Additionally, the weight of the value is taken into account.\nuniq\nCalculates the approximate number of different values of the argument.\nuniqCombined\nCalculates the approximate number of different argument values.\nuniqCombined64\nCalculates the approximate number of different argument values. It is the same as uniqCombined, but uses a 64-bit hash for all data types rather than just for the String data type.\nuniqExact\nCalculates the exact number of different argument values.\nuniqHLL12\nCalculates the approximate number of different argument values, using the HyperLogLog algorithm.\nuniqTheta\nCalculates the approximate number of different argument values, using the Theta Sketch Framework.\nvarPop\nCalculates the population variance.\nvarPopStable\nReturns the population variance. Unlike varPop , this function uses a numerically stable algorithm. It works slower but provides a lower computational error.\nvarSamp\nCalculate the sample variance of a data set.\nvarSampStable\nCalculate the sample variance of a data set. Unlike\nvarSamp\n, this function uses a numerically stable algorithm. It works slower but provides a lower computational error.\nwelchTTest\nApplies Welch's t-test to samples from two populations.","attrs_markdown":"[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference#__docusaurus_skipToContent_fallback)\n\n[![ClickHouse](https:\/\/clickhouse.com\/docs\/img\/ch_logo_docs.svg)](https:\/\/clickhouse.com\/)\n\n- [Products](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n  \n  - [ClickHouse Cloud Best way to use ClickHouse. Available on AWS, GCP, and Azure.](https:\/\/clickhouse.com\/cloud)\n  - [BYOC (Bring Your Own Cloud) The fully managed ClickHouse Cloud service, Can be deployed in your AWS account.](https:\/\/clickhouse.com\/cloud\/bring-your-own-cloud)\n  - [ClickHouse Set up a database with open-source ClickHouse. ClickHouse](https:\/\/clickhouse.com\/clickhouse)\n  - [Discover more than 100 integrations.](https:\/\/clickhouse.com\/integrations)\n  \n  [Discover more than 100 integrations.](https:\/\/clickhouse.com\/integrations)\n- [Use cases](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n  \n  - [Real-time analytics](https:\/\/clickhouse.com\/use-cases\/real-time-analytics)\n  - [Machine Learning & Generative AI](https:\/\/clickhouse.com\/use-cases\/machine-learning-and-data-science)\n  - [Business Intelligence](https:\/\/clickhouse.com\/use-cases\/data-warehousing)\n  - [Logs, Events, Traces](https:\/\/clickhouse.com\/use-cases\/observability)\n  - [All use cases](https:\/\/clickhouse.com\/use-cases)\n  \n  [All use cases](https:\/\/clickhouse.com\/use-cases)\n- [Documentation](https:\/\/clickhouse.com\/docs)\n- [Resources](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n  \n  - [User stories](https:\/\/clickhouse.com\/user-stories)\n  - [Blog](https:\/\/clickhouse.com\/blog)\n  - [Events](https:\/\/clickhouse.com\/company\/events)\n  - [Learning and certification](https:\/\/clickhouse.com\/learn)\n  - [Comparison](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n    - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n    - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n    - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n    - [Rockset](https:\/\/clickhouse.com\/comparison\/rockset)\n    - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n  - [Video](https:\/\/clickhouse.com\/videos)\n  - [Demo](https:\/\/clickhouse.com\/demos)\n- [Pricing](https:\/\/clickhouse.com\/pricing)\n- [Contact](https:\/\/clickhouse.com\/company\/contact?loc=nav)\n\n[46\\.7k](https:\/\/github.com\/ClickHouse\/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav)\n\n[Search`Ctrl``K`](https:\/\/clickhouse.com\/docs\/search)\n\n[Sign in](https:\/\/console.clickhouse.cloud\/signIn?loc=docs-nav-signIn-cta&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985)\n\n[Get started](https:\/\/clickhouse.com\/docs\/introduction-clickhouse)\n\n[Cloud](https:\/\/clickhouse.com\/docs\/cloud\/overview)\n\n[Manage data](https:\/\/clickhouse.com\/docs\/updating-data)\n\n[Server admin](https:\/\/clickhouse.com\/docs\/guides\/manage-and-deploy-index)\n\n[Reference](https:\/\/clickhouse.com\/docs\/sql-reference)\n\n[Integrations](https:\/\/clickhouse.com\/docs\/integrations)\n\n[ClickStack](https:\/\/clickhouse.com\/docs\/use-cases\/observability\/clickstack\/overview)\n\n[chDB](https:\/\/clickhouse.com\/docs\/chdb)\n\n[About](https:\/\/clickhouse.com\/docs\/about)\n\n[Knowledge Base](https:\/\/clickhouse.com\/docs\/knowledgebase)\n\n[English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/aggregate-functions\/reference)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/aggregate-functions\/reference)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/aggregate-functions\/reference)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/aggregate-functions\/reference)\n\n[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference#__docusaurus_skipToContent_fallback)\n\n[![ClickHouse](https:\/\/clickhouse.com\/docs\/img\/ch_logo_docs.svg)](https:\/\/clickhouse.com\/)\n\n- [Products](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n  \n  - [ClickHouse Cloud Best way to use ClickHouse. Available on AWS, GCP, and Azure.](https:\/\/clickhouse.com\/cloud)\n  - [BYOC (Bring Your Own Cloud) The fully managed ClickHouse Cloud service, Can be deployed in your AWS account.](https:\/\/clickhouse.com\/cloud\/bring-your-own-cloud)\n  - [ClickHouse Set up a database with open-source ClickHouse. ClickHouse](https:\/\/clickhouse.com\/clickhouse)\n  - [Discover more than 100 integrations.](https:\/\/clickhouse.com\/integrations)\n  \n  [Discover more than 100 integrations.](https:\/\/clickhouse.com\/integrations)\n- [Use cases](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n  \n  - [Real-time analytics](https:\/\/clickhouse.com\/use-cases\/real-time-analytics)\n  - [Machine Learning & Generative AI](https:\/\/clickhouse.com\/use-cases\/machine-learning-and-data-science)\n  - [Business Intelligence](https:\/\/clickhouse.com\/use-cases\/data-warehousing)\n  - [Logs, Events, Traces](https:\/\/clickhouse.com\/use-cases\/observability)\n  - [All use cases](https:\/\/clickhouse.com\/use-cases)\n  \n  [All use cases](https:\/\/clickhouse.com\/use-cases)\n- [Documentation](https:\/\/clickhouse.com\/docs)\n- [Resources](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n  \n  - [User stories](https:\/\/clickhouse.com\/user-stories)\n  - [Blog](https:\/\/clickhouse.com\/blog)\n  - [Events](https:\/\/clickhouse.com\/company\/events)\n  - [Learning and certification](https:\/\/clickhouse.com\/learn)\n  - [Comparison](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n    - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n    - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n    - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n    - [Rockset](https:\/\/clickhouse.com\/comparison\/rockset)\n    - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n  - [Video](https:\/\/clickhouse.com\/videos)\n  - [Demo](https:\/\/clickhouse.com\/demos)\n- [Pricing](https:\/\/clickhouse.com\/pricing)\n- [Contact](https:\/\/clickhouse.com\/company\/contact?loc=nav)\n\n[46\\.7k](https:\/\/github.com\/ClickHouse\/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav)\n\n[Search`Ctrl``K`](https:\/\/clickhouse.com\/docs\/search)\n\n[Sign in](https:\/\/console.clickhouse.cloud\/signIn?loc=docs-nav-signIn-cta&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985)\n\n[Get started](https:\/\/clickhouse.com\/docs\/introduction-clickhouse)\n\n[Cloud](https:\/\/clickhouse.com\/docs\/cloud\/overview)\n\n[Manage data](https:\/\/clickhouse.com\/docs\/updating-data)\n\n[Server admin](https:\/\/clickhouse.com\/docs\/guides\/manage-and-deploy-index)\n\n[Reference](https:\/\/clickhouse.com\/docs\/sql-reference)\n\n[Integrations](https:\/\/clickhouse.com\/docs\/integrations)\n\n[ClickStack](https:\/\/clickhouse.com\/docs\/use-cases\/observability\/clickstack\/overview)\n\n[chDB](https:\/\/clickhouse.com\/docs\/chdb)\n\n[About](https:\/\/clickhouse.com\/docs\/about)\n\n[Knowledge Base](https:\/\/clickhouse.com\/docs\/knowledgebase)\n\n[English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/aggregate-functions\/reference)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/aggregate-functions\/reference)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/aggregate-functions\/reference)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/aggregate-functions\/reference)\n\n[Search`Ctrl``K`](https:\/\/clickhouse.com\/docs\/search)\n\n- [Introduction](https:\/\/clickhouse.com\/docs\/sql-reference)\n  - [Syntax](https:\/\/clickhouse.com\/docs\/sql-reference\/syntax)\n  - [Input and Output Formats](https:\/\/clickhouse.com\/docs\/sql-reference\/formats)\n  - [Data types](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types)\n  - [Statements](https:\/\/clickhouse.com\/docs\/sql-reference\/statements)\n  - [Operators](https:\/\/clickhouse.com\/docs\/sql-reference\/operators)\n- [Engines](https:\/\/clickhouse.com\/docs\/engines)\n  - [Database Engines](https:\/\/clickhouse.com\/docs\/engines\/database-engines)\n  - [Table Engines](https:\/\/clickhouse.com\/docs\/engines\/table-engines)\n- [Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/functions)\n  - [Regular functions](https:\/\/clickhouse.com\/docs\/sql-reference\/functions\/regular-functions)\n  - [Aggregate functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions)\n    - [Aggregate Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n      - [aggThrow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/aggthrow)\n      - [analysisOfVariance](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/analysis_of_variance)\n      - [any](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/any)\n      - [anyHeavy](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/anyheavy)\n      - [anyLast](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/anylast)\n      - [approx\\_top\\_k](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/approxtopk)\n      - [approx\\_top\\_sum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/approxtopsum)\n      - [argAndMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argandmax)\n      - [argAndMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argandmin)\n      - [argMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax)\n      - [argMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmin)\n      - [avg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/avg)\n      - [avgWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/avgweighted)\n      - [boundingRatio](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/boundingRatio)\n      - [categoricalInformationValue](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/categoricalinformationvalue)\n      - [contingency](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/contingency)\n      - [corr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corr)\n      - [corrMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corrmatrix)\n      - [corrStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corrstable)\n      - [count](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/count)\n      - [covarPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpop)\n      - [covarPopMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpopmatrix)\n      - [covarPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpopstable)\n      - [covarSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsamp)\n      - [covarSampMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsampmatrix)\n      - [covarSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsampstable)\n      - [cramersV](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/cramersv)\n      - [cramersVBiasCorrected](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/cramersvbiascorrected)\n      - [deltaSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/deltasum)\n      - [deltaSumTimestamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/deltasumtimestamp)\n      - [distinctDynamicTypes](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctdynamictypes)\n      - [distinctJSONPaths](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctjsonpaths)\n      - [distinctJSONPathsAndTypes](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctJSONPathsAndTypes)\n      - [entropy](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/entropy)\n      - [estimateCompressionRatio](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/estimateCompressionRatio)\n      - [exponentialMovingAverage](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialMovingAverage)\n      - [exponentialTimeDecayedAvg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedAvg)\n      - [exponentialTimeDecayedCount](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedCount)\n      - [exponentialTimeDecayedMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedMax)\n      - [exponentialTimeDecayedSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedSum)\n      - [first\\_value](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value)\n      - [flameGraph](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/flame_graph)\n      - [groupArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparray)\n      - [groupArrayArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayarray)\n      - [groupArrayInsertAt](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayinsertat)\n      - [groupArrayIntersect](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayintersect)\n      - [groupArrayLast](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraylast)\n      - [groupArrayMovingAvg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraymovingavg)\n      - [groupArrayMovingSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraymovingsum)\n      - [groupArraySample](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraysample)\n      - [groupArraySorted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraysorted)\n      - [groupBitAnd](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitand)\n      - [groupBitOr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitor)\n      - [groupBitXor](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitxor)\n      - [groupBitmap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap)\n      - [groupBitmapAnd](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapand)\n      - [groupBitmapOr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapor)\n      - [groupBitmapXor](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapxor)\n      - [groupConcat](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupconcat)\n      - [groupUniqArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupuniqarray)\n      - [intervalLengthSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/intervalLengthSum)\n      - [kolmogorovSmirnovTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kolmogorovsmirnovtest)\n      - [kurtPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kurtpop)\n      - [kurtSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kurtsamp)\n      - [largestTriangleThreeBuckets](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/largestTriangleThreeBuckets)\n      - [last\\_value](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/last_value)\n      - [mannWhitneyUTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/mannwhitneyutest)\n      - [max](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/max)\n      - [maxIntersections](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxintersections)\n      - [maxIntersectionsPosition](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxintersectionsposition)\n      - [maxMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxmap)\n      - [meanZTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/meanztest)\n      - [median](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/median)\n      - [min](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/min)\n      - [minMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/minmap)\n      - [quantile](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantile)\n      - [quantileBFloat16](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilebfloat16)\n      - [quantileDD](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileddsketch)\n      - [quantileDeterministic](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiledeterministic)\n      - [quantileExact Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileexact)\n      - [quantileExactExclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactExclusive)\n      - [quantileExactHigh](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactHigh)\n      - [quantileExactInclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactInclusive)\n      - [quantileExactLow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactLow)\n      - [quantileExactWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileexactweighted)\n      - [quantileExactWeightedInterpolated](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactWeightedInterpolated)\n      - [quantileGK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileGK)\n      - [quantileInterpolatedWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileInterpolatedWeighted)\n      - [quantilePrometheusHistogram](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilePrometheusHistogram)\n      - [quantileTDigest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletdigest)\n      - [quantileTDigestWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletdigestweighted)\n      - [quantileTiming](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletiming)\n      - [quantileTimingWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletimingweighted)\n      - [quantiles Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiles)\n      - [quantilesExactExclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesExactExclusive)\n      - [quantilesExactInclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesExactInclusive)\n      - [quantilesGK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesGK)\n      - [quantilesTimingWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilestimingweighted)\n      - [rankCorr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/rankCorr)\n      - [simpleLinearRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/simplelinearregression)\n      - [singleValueOrNull](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/singlevalueornull)\n      - [skewPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/skewpop)\n      - [skewSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/skewsamp)\n      - [sparkbar](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sparkbar)\n      - [stddevPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevpop)\n      - [stddevPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevpopstable)\n      - [stddevSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevsamp)\n      - [stddevSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevsampstable)\n      - [stochasticLinearRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stochasticlinearregression)\n      - [stochasticLogisticRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stochasticlogisticregression)\n      - [studentTTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/studentttest)\n      - [studentTTestOneSample](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/studentttestonesample)\n      - [sum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sum)\n      - [sumCount](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumcount)\n      - [sumKahan](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumkahan)\n      - [sumMapWithOverflow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/summapwithoverflow)\n      - [sumMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/summap)\n      - [sumWithOverflow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumwithoverflow)\n      - [theilsU](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/theilsu)\n      - [timeSeriesChangesToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesChangesToGrid)\n      - [timeSeriesDeltaToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesDeltaToGrid)\n      - [timeSeriesDerivToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesDerivToGrid)\n      - [timeSeriesGroupArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesGroupArray)\n      - [timeSeriesInstantDeltaToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesInstantDeltaToGrid)\n      - [timeSeriesInstantRateToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesInstantRateToGrid)\n      - [timeSeriesLastTwoSamples](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesLastTwoSamples)\n      - [timeSeriesPredictLinearToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesPredictLinearToGrid)\n      - [timeSeriesRateToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesRateToGrid)\n      - [timeSeriesResampleToGridWithStaleness](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesResampleToGridWithStaleness)\n      - [timeSeriesResetsToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesResetsToGrid)\n      - [topK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/topk)\n      - [topKWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/topkweighted)\n      - [uniq](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniq)\n      - [uniqCombined](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqcombined)\n      - [uniqCombined64](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqcombined64)\n      - [uniqExact](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqexact)\n      - [uniqHLL12](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqhll12)\n      - [uniqTheta](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqthetasketch)\n      - [varPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varPop)\n      - [varPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varpopstable)\n      - [varSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varSamp)\n      - [varSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varsampstable)\n      - [welchTTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/welchttest)\n    - [Combinators](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/combinators)\n    - [Parametric](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/parametric-functions)\n    - [GROUPING](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/grouping_function)\n    - [Combinator examples](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n  - [Table functions](https:\/\/clickhouse.com\/docs\/sql-reference\/table-functions)\n  - [Window functions](https:\/\/clickhouse.com\/docs\/sql-reference\/window-functions)\n- [Formats](https:\/\/clickhouse.com\/docs\/interfaces\/formats)\n- [Data Lakes](https:\/\/clickhouse.com\/docs\/sql-reference\/datalakes)\n\n- [Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/functions)\n- [Aggregate functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions)\n- Aggregate Functions\n\n[Edit this page](https:\/\/github.com\/ClickHouse\/ClickHouse\/tree\/master\/docs\/en\/sql-reference\/aggregate-functions\/reference\/index.md)\n\n# Aggregate functions\nClickHouse supports all standard SQL aggregate functions ([sum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sum), [avg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/avg), [min](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/min), [max](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/max), [count](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/count)), as well as a wide range of other aggregate functions.\n\n| Page | Description |\n|---|---|\n| [aggThrow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/aggthrow) | This function can be used for the purpose of testing exception safety. It will throw an exception on creation with the specified probability. |\n| [analysisOfVariance](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/analysis_of_variance) | Provides a statistical test for one-way analysis of variance (ANOVA test). It is a test over several groups of normally distributed observations to find out whether all groups have the same mean or not. |\n| [any](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/any) | Selects the first encountered value of a column. |\n| [anyHeavy](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/anyheavy) | Selects a frequently occurring value using the heavy hitters algorithm. If there is a value that occurs more than in half the cases in each of the query execution threads, this value is returned. Normally, the result is nondeterministic. |\n| [anyLast](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/anylast) | Selects the last encountered value of a column. |\n| [approx\\_top\\_k](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/approxtopk) | Returns an array of the approximately most frequent values and their counts in the specified column. |\n| [approx\\_top\\_sum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/approxtopsum) | Returns an array of the approximately most frequent values and their counts in the specified column. |\n| [argAndMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argandmax) | Calculates the `arg` and `val` value for a maximum `val` value. If there are multiple rows with equal `val` being the maximum, which of the associated `arg` and `val` is returned is not deterministic. |\n| [argAndMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argandmin) | Calculates the `arg` and `val` value for a minimum `val` value. If there are multiple rows with equal `val` being the minimum, which of the associated `arg` and `val` is returned is not deterministic. |\n| [argMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax) | Calculates the `arg` value for a maximum `val` value. |\n| [argMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmin) | Calculates the `arg` value for a minimum `val` value. If there are multiple rows with equal `val` being the maximum, which of the associated `arg` is returned is not deterministic. |\n| [avg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/avg) | Calculates the arithmetic mean. |\n| [avgWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/avgweighted) | Calculates the weighted arithmetic mean. |\n| [boundingRatio](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/boundingRatio) | Aggregate function that calculates the slope between the leftmost and rightmost points across a group of values. |\n| [categoricalInformationValue](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/categoricalinformationvalue) | Calculates the value of `(P(tag = 1) - P(tag = 0))(log(P(tag = 1)) - log(P(tag = 0)))` for each category. |\n| [contingency](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/contingency) | The `contingency` function calculates the contingency coefficient, a value that measures the association between two columns in a table. The computation is similar to the `cramersV` function but with a different denominator in the square root. |\n| [corr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corr) | Calculates the Pearson correlation coefficient. |\n| [corrMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corrmatrix) | Computes the correlation matrix over N variables. |\n| [corrStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/corrstable) | Calculates the Pearson correlation coefficient, but uses a numerically stable algorithm. |\n| [count](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/count) | Counts the number of rows or not-NULL values. |\n| [covarPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpop) | Calculates the population covariance |\n| [covarPopMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpopmatrix) | Returns the population covariance matrix over N variables. |\n| [covarPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarpopstable) | Calculates the value of the population covariance |\n| [covarSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsamp) | Calculates the value of `Σ((x - x̅)(y - y̅)) \/ (n - 1)` |\n| [covarSampMatrix](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsampmatrix) | Returns the sample covariance matrix over N variables. |\n| [covarSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/covarsampstable) | Similar to covarSamp but works slower while providing a lower computational error. |\n| [cramersV](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/cramersv) | The result of the `cramersV` function ranges from 0 (corresponding to no association between the variables) to 1 and can reach 1 only when each value is completely determined by the other. It may be viewed as the association between two variables as a percentage of their maximum possible variation. |\n| [cramersVBiasCorrected](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/cramersvbiascorrected) | Calculates Cramer's V, but uses a bias correction. |\n| [deltaSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/deltasum) | Sums the arithmetic difference between consecutive rows. |\n| [deltaSumTimestamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/deltasumtimestamp) | Adds the difference between consecutive rows. If the difference is negative, it is ignored. |\n| [distinctDynamicTypes](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctdynamictypes) | Calculates the list of distinct data types stored in Dynamic column. |\n| [distinctJSONPaths](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctjsonpaths) | Calculates a list of distinct paths stored in a JSON column. |\n| [distinctJSONPathsAndTypes](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/distinctJSONPathsAndTypes) | Calculates the list of distinct paths and their types stored in JSON |\n| [entropy](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/entropy) | Calculates Shannon entropy of for a column of values. |\n| [estimateCompressionRatio](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/estimateCompressionRatio) | Estimates the compression ratio of a given column without compressing it. |\n| [exponentialMovingAverage](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialMovingAverage) | Calculates the exponential moving average of values for the determined time. |\n| [exponentialTimeDecayedAvg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedAvg) | Returns the exponentially smoothed weighted moving average of values of a time series at point `t` in time. |\n| [exponentialTimeDecayedCount](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedCount) | Returns the cumulative exponential decay over a time series at the index `t` in time. |\n| [exponentialTimeDecayedMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedMax) | Returns the maximum of the computed exponentially smoothed moving average at index `t` in time with that at `t-1`. |\n| [exponentialTimeDecayedSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedSum) | Returns the sum of exponentially smoothed moving average values of a time series at the index `t` in time. |\n| [first\\_value](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value) | It is an alias for any but it was introduced for compatibility with Window Functions, where sometimes it is necessary to process `NULL` values (by default all ClickHouse aggregate functions ignore NULL values). |\n| [flameGraph](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/flame_graph) | Aggregate function which builds a flamegraph using the list of stacktraces. |\n| [groupArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparray) | Creates an array of argument values. Values can be added to the array in any (indeterminate) order. |\n| [groupArrayArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayarray) | Aggregates arrays into a larger array of those arrays. |\n| [groupArrayInsertAt](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayinsertat) | Inserts a value into the array at the specified position. |\n| [groupArrayIntersect](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparrayintersect) | Return an intersection of given arrays (Return all items of arrays, that are in all given arrays). |\n| [groupArrayLast](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraylast) | Creates an array of the last argument values. |\n| [groupArrayMovingAvg](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraymovingavg) | Calculates the moving average of input values. |\n| [groupArrayMovingSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraymovingsum) | Calculates the moving sum of input values. |\n| [groupArraySample](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraysample) | Creates an array of sample argument values. The size of the resulting array is limited to `max_size` elements. Argument values are selected and added to the array randomly. |\n| [groupArraySorted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/grouparraysorted) | Returns an array with the first N items in ascending order. |\n| [groupBitAnd](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitand) | Applies bit-wise `AND` for series of numbers. |\n| [groupBitmap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmap) | Bitmap or Aggregate calculations from a unsigned integer column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object |\n| [groupBitmapAnd](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapand) | Calculations the AND of a bitmap column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object. |\n| [groupBitmapOr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapor) | Calculations the OR of a bitmap column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object. This is equivalent to `groupBitmapMerge`. |\n| [groupBitmapXor](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitmapxor) | Calculates the XOR of a bitmap column, and returns the cardinality of type UInt64, if used with suffix -State, then it returns a bitmap object |\n| [groupBitOr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitor) | Applies bit-wise `OR` to a series of numbers. |\n| [groupBitXor](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupbitxor) | Applies bit-wise `XOR` for series of numbers. |\n| [groupConcat](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupconcat) | Calculates a concatenated string from a group of strings, optionally separated by a delimiter, and optionally limited by a maximum number of elements. |\n| [groupUniqArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/groupuniqarray) | Creates an array from different argument values. |\n| [intervalLengthSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/intervalLengthSum) | Calculates the total length of union of all ranges (segments on numeric axis). |\n| [kolmogorovSmirnovTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kolmogorovsmirnovtest) | Applies Kolmogorov-Smirnov's test to samples from two populations. |\n| [kurtPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kurtpop) | Computes the kurtosis of a sequence. |\n| [kurtSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/kurtsamp) | Computes the sample kurtosis of a sequence. |\n| [largestTriangleThreeBuckets](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/largestTriangleThreeBuckets) | Applies the Largest-Triangle-Three-Buckets algorithm to the input data. |\n| [last\\_value](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/last_value) | Selects the last encountered value, similar to `anyLast`, but could accept NULL. |\n| [mannWhitneyUTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/mannwhitneyutest) | Applies the Mann-Whitney rank test to samples from two populations. |\n| [max](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/max) | Aggregate function that calculates the maximum across a group of values. |\n| [maxIntersections](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxintersections) | Aggregate function that calculates the maximum number of times that a group of intervals intersects each other (if all the intervals intersect at least once). |\n| [maxIntersectionsPosition](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxintersectionsposition) | Aggregate function that calculates the positions of the occurrences of the maxIntersections function. |\n| [maxMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/maxmap) | Calculates the maximum from `value` array according to the keys specified in the `key` array. |\n| [meanZTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/meanztest) | Applies mean z-test to samples from two populations. |\n| [median](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/median) | The `median*` functions are the aliases for the corresponding `quantile*` functions. They calculate median of a numeric data sample. |\n| [min](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/min) | Aggregate function that calculates the minimum across a group of values. |\n| [minMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/minmap) | Calculates the minimum from `value` array according to the keys specified in the `key` array. |\n| [quantile](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantile) | Computes an approximate quantile of a numeric data sequence. |\n| [quantileBFloat16](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilebfloat16) | Computes an approximate quantile of a sample consisting of bfloat16 numbers. |\n| [quantileDD](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileddsketch) | Computes an approximate quantile of a sample with relative-error guarantees. |\n| [quantileDeterministic](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiledeterministic) | Computes an approximate quantile of a numeric data sequence. |\n| [quantileExact Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileexact) | quantileExact, quantileExactLow, quantileExactHigh, quantileExactExclusive, quantileExactInclusive functions |\n| [quantileExactExclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactExclusive) | Exactly computes the quantile of a numeric data sequence. |\n| [quantileExactHigh](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactHigh) | Similar to quantileExact, this computes the exact quantile of a numeric data sequence. |\n| [quantileExactInclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactInclusive) | Exactly computes the quantile of a numeric data sequence. |\n| [quantileExactLow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactLow) | Similar to quantileExact, this computes the exact [quantile](https:\/\/en.wikipedia.org\/wiki\/Quantile) of a numeric data sequence. |\n| [quantileExactWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileexactweighted) | Exactly computes the quantile of a numeric data sequence, taking into account the weight of each element. |\n| [quantileExactWeightedInterpolated](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileExactWeightedInterpolated) | Computes quantile of a numeric data sequence using linear interpolation, taking into account the weight of each element. |\n| [quantileGK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileGK) | Computes the quantile of a numeric data sequence using the Greenwald-Khanna algorithm. |\n| [quantileInterpolatedWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantileInterpolatedWeighted) | Computes quantile of a numeric data sequence using linear interpolation, taking into account the weight of each element. |\n| [quantilePrometheusHistogram](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilePrometheusHistogram) | Computes quantile of a histogram using linear interpolation. |\n| [quantiles Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiles) | quantiles, quantilesExactExclusive, quantilesExactInclusive, quantilesGK |\n| [quantilesExactExclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesExactExclusive) | Exactly computes the quantiles of a numeric data sequence. |\n| [quantilesExactInclusive](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesExactInclusive) | Exactly computes the quantiles of a numeric data sequence. |\n| [quantilesGK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilesGK) | quantilesGK works similarly to quantileGK but allows us to calculate quantities at different levels simultaneously and returns an array. |\n| [quantilesTimingWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantilestimingweighted) | With the determined precision computes the quantile of a numeric data sequence according to the weight of each sequence member. |\n| [quantileTDigest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletdigest) | Computes an approximate quantile of a numeric data sequence using the t-digest algorithm. |\n| [quantileTDigestWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletdigestweighted) | Computes an approximate quantile of a numeric data sequence using the t-digest algorithm. |\n| [quantileTiming](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletiming) | With the determined precision computes the quantile of a numeric data sequence. |\n| [quantileTimingWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/quantiletimingweighted) | With the determined precision computes the quantile of a numeric data sequence according to the weight of each sequence member. |\n| [rankCorr](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/rankCorr) | Computes a rank correlation coefficient. |\n| [simpleLinearRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/simplelinearregression) | Performs simple (unidimensional) linear regression. |\n| [singleValueOrNull](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/singlevalueornull) | The aggregate function `singleValueOrNull` is used to implement subquery operators, such as `x = ALL (SELECT ...)`. It checks if there is only one unique non-NULL value in the data. |\n| [skewPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/skewpop) | Computes the skewness of a sequence. |\n| [skewSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/skewsamp) | Computes the sample skewness of a sequence. |\n| [sparkbar](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sparkbar) | The function plots a frequency histogram for values `x` and the repetition rate `y` of these values over the interval `[min_x, max_x]`. |\n| [stddevPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevpop) | The result is equal to the square root of varPop. |\n| [stddevPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevpopstable) | The result is equal to the square root of varPop. Unlike stddevPop, this function uses a numerically stable algorithm. |\n| [stddevSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevsamp) | The result is equal to the square root of varSamp |\n| [stddevSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stddevsampstable) | The result is equal to the square root of varSamp. Unlike this function uses a numerically stable algorithm. |\n| [stochasticLinearRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stochasticlinearregression) | This function implements stochastic linear regression. It supports custom parameters for learning rate, L2 regularization coefficient, mini-batch size, and has a few methods for updating weights (Adam, simple SGD, Momentum, Nesterov.) |\n| [stochasticLogisticRegression](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/stochasticlogisticregression) | This function implements stochastic logistic regression. It can be used for binary classification problem, supports the same custom parameters as stochasticLinearRegression and works the same way. |\n| [studentTTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/studentttest) | Applies the student t-test to samples from two populations. |\n| [studentTTestOneSample](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/studentttestonesample) | Applies the one-sample Student t-test to a sample and a known population mean. |\n| [sum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sum) | Calculates the sum. Only works for numbers. |\n| [sumCount](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumcount) | Calculates the sum of the numbers and counts the number of rows at the same time. The function is used by ClickHouse query optimizer: if there are multiple `sum`, `count` or `avg` functions in a query, they can be replaced to single `sumCount` function to reuse the calculations. The function is rarely needed to use explicitly. |\n| [sumKahan](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumkahan) | Calculates the sum of the numbers with Kahan compensated summation algorithm |\n| [sumMap](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/summap) | Totals one or more `value` arrays according to the keys specified in the `key` array. Returns a tuple of arrays: keys in sorted order, followed by values summed for the corresponding keys without overflow. |\n| [sumMapWithOverflow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/summapwithoverflow) | Totals a `value` array according to the keys specified in the `key` array. Returns a tuple of two arrays: keys in sorted order, and values summed for the corresponding keys. Differs from the sumMap function in that it does summation with overflow. |\n| [sumWithOverflow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/sumwithoverflow) | Computes the sum of the numbers, using the same data type for the result as for the input parameters. If the sum exceeds the maximum value for this data type, it is calculated with overflow. |\n| [theilsU](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/theilsu) | The `theilsU` function calculates Theils' U uncertainty coefficient, a value that measures the association between two columns in a table. |\n| [timeSeriesChangesToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesChangesToGrid) | Aggregate function that calculates PromQL-like changes over time series data on the specified grid. |\n| [timeSeriesDeltaToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesDeltaToGrid) | Aggregate function that calculates PromQL-like delta over time series data on the specified grid. |\n| [timeSeriesDerivToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesDerivToGrid) | Aggregate function that calculates PromQL-like derivative over time series data on the specified grid. |\n| [timeSeriesGroupArray](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesGroupArray) | Sorts time series by timestamp in ascending order. |\n| [timeSeriesInstantDeltaToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesInstantDeltaToGrid) | Aggregate function that calculates PromQL-like idelta over time series data on the specified grid. |\n| [timeSeriesInstantRateToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesInstantRateToGrid) | Aggregate function that calculates PromQL-like irate over time series data on the specified grid. |\n| [timeSeriesLastTwoSamples](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesLastTwoSamples) | Aggregate function for re-sampling time series data for PromQL-like irate and idelta calculation |\n| [timeSeriesPredictLinearToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesPredictLinearToGrid) | Aggregate function that calculates PromQL-like linear prediction over time series data on the specified grid. |\n| [timeSeriesRateToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesRateToGrid) | Aggregate function that calculates PromQL-like rate over time series data on the specified grid. |\n| [timeSeriesResampleToGridWithStaleness](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesResampleToGridWithStaleness) | Aggregate function that re-samples time series data to the specified grid. |\n| [timeSeriesResetsToGrid](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/timeSeriesResetsToGrid) | Aggregate function that calculates PromQL-like resets over time series data on the specified grid. |\n| [topK](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/topk) | Returns an array of the approximately most frequent values in the specified column. The resulting array is sorted in descending order of approximate frequency of values (not by the values themselves). |\n| [topKWeighted](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/topkweighted) | Returns an array of the approximately most frequent values in the specified column. The resulting array is sorted in descending order of approximate frequency of values (not by the values themselves). Additionally, the weight of the value is taken into account. |\n| [uniq](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniq) | Calculates the approximate number of different values of the argument. |\n| [uniqCombined](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqcombined) | Calculates the approximate number of different argument values. |\n| [uniqCombined64](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqcombined64) | Calculates the approximate number of different argument values. It is the same as uniqCombined, but uses a 64-bit hash for all data types rather than just for the String data type. |\n| [uniqExact](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqexact) | Calculates the exact number of different argument values. |\n| [uniqHLL12](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqhll12) | Calculates the approximate number of different argument values, using the HyperLogLog algorithm. |\n| [uniqTheta](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/uniqthetasketch) | Calculates the approximate number of different argument values, using the Theta Sketch Framework. |\n| [varPop](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varPop) | Calculates the population variance. |\n| [varPopStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varpopstable) | Returns the population variance. Unlike varPop , this function uses a numerically stable algorithm. It works slower but provides a lower computational error. |\n| [varSamp](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varSamp) | Calculate the sample variance of a data set. |\n| [varSampStable](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/varsampstable) | Calculate the sample variance of a data set. Unlike `varSamp` , this function uses a numerically stable algorithm. It works slower but provides a lower computational error. |\n| [welchTTest](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/welchttest) | Applies Welch's t-test to samples from two populations. |\n\n[Previous Aggregate Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions)\n\n[Next aggThrow](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/aggthrow)\n\nWas this page helpful?\n\n###### Try ClickHouse Cloud for FREE\nSeparation of storage and compute, automatic scaling, built-in SQL console, and lots more. \\$300 in free credits when signing up.\n\n[Try it for Free](https:\/\/console.clickhouse.cloud\/signUp?loc=doc-card-banner&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985)\n\n© 2016–2026 ClickHouse, Inc.\n\n[Trademark](https:\/\/clickhouse.com\/legal\/trademark-policy)·[Privacy](https:\/\/clickhouse.com\/legal\/privacy-policy)·[Security](https:\/\/trust.clickhouse.com\/)·[Terms of Service](https:\/\/clickhouse.com\/legal\/agreements\/terms-of-service)\n\n![](https:\/\/static.scarf.sh\/a.png?x-pxid=e6377503-591b-4886-9398-e69c7fee0b91)\n\n© 2016–2026 ClickHouse, Inc.\n\n[Trademark](https:\/\/clickhouse.com\/legal\/trademark-policy)·[Privacy](https:\/\/clickhouse.com\/legal\/privacy-policy)·[Security](https:\/\/trust.clickhouse.com\/)·[Terms of Service](https:\/\/clickhouse.com\/legal\/agreements\/terms-of-service)\n\n![](https:\/\/static.scarf.sh\/a.png?x-pxid=e6377503-591b-4886-9398-e69c7fee0b91)\n\n[![ClickHouse](https:\/\/clickhouse.com\/docs\/img\/ch_logo_docs.svg)](https:\/\/clickhouse.com\/)\n\nEN\n\n- Get started▼\n- Cloud▼\n- Manage data▼\n- Server admin▼\n- Reference▼\n- Integrations▼\n- ClickStack▼\n- chDB▼\n- About▼\n\n[![ClickHouse](https:\/\/clickhouse.com\/docs\/img\/ch_logo_docs.svg)](https:\/\/clickhouse.com\/)\n\nEN\n\nmain-menu\n\n- Introduction▼\n  - [Syntax](https:\/\/clickhouse.com\/docs\/sql-reference\/syntax)\n  - [Input and Output Formats](https:\/\/clickhouse.com\/docs\/sql-reference\/formats)\n  - Data types▼\n  - Statements▼\n  - Operators▼\n- Engines▼\n- Functions▼\n- Formats▼\n- [Data Lakes](https:\/\/clickhouse.com\/docs\/sql-reference\/datalakes)","attrs_readable_markdown":null,"meta_canonical":null}

3. Robots.txt Check

Query:

Response:

4. Spam/Ban Check

Query:

Response:

5. Seen Status Check

ℹ️ Skipped - page is already crawled

📄

INDEXABLE

✅

CRAWLED

3 days ago

🤖

ROBOTS ALLOWED

Page Info Filters

Filter	Status	Condition	Details
HTTP status	PASS	`download_http_code = 200`	HTTP 200
Age cutoff	PASS	`download_stamp > now() - 6 MONTH`	0.1 months ago
History drop	PASS	`isNull(history_drop_reason)`	No drop reason
Spam/ban	PASS	`fh_dont_index != 1 AND ml_spam_score = 0`	ml_spam_score=0
Canonical	PASS	`meta_canonical IS NULL OR = '' OR = src_unparsed`	Not set

Page Details

Property	Value
URL	https://clickhouse.com/docs/sql-reference/aggregate-functions/reference
Last Crawled	2026-04-03 20:09:43 (3 days ago)
First Indexed	2025-02-21 03:23:37 (1 year ago)
HTTP Status Code	200
Meta Title	Aggregate Functions \| ClickHouse Docs
Meta Description	Landing page for aggregate functions with complete list of aggregate functions
Meta Canonical	null
Boilerpipe Text	aggThrow This function can be used for the purpose of testing exception safety. It will throw an exception on creation with the specified probability. analysisOfVariance Provides a statistical test for one-way analysis of variance (ANOVA test). It is a test over several groups of normally distributed observations to find out whether all groups have the same mean or not. any Selects the first encountered value of a column. anyHeavy Selects a frequently occurring value using the heavy hitters algorithm. If there is a value that occurs more than in half the cases in each of the query execution threads, this value is returned. Normally, the result is nondeterministic. anyLast Selects the last encountered value of a column. approx_top_k Returns an array of the approximately most frequent values and their counts in the specified column. approx_top_sum Returns an array of the approximately most frequent values and their counts in the specified column. argAndMax Calculates the arg and val value for a maximum val value. If there are multiple rows with equal val being the maximum, which of the associated arg and val is returned is not deterministic. argAndMin Calculates the arg and val value for a minimum val value. If there are multiple rows with equal val being the minimum, which of the associated arg and val is returned is not deterministic. argMax Calculates the arg value for a maximum val value. argMin Calculates the arg value for a minimum val value. If there are multiple rows with equal val being the maximum, which of the associated arg is returned is not deterministic. avg Calculates the arithmetic mean. avgWeighted Calculates the weighted arithmetic mean. boundingRatio Aggregate function that calculates the slope between the leftmost and rightmost points across a group of values. categoricalInformationValue Calculates the value of (P(tag = 1) - P(tag = 0))(log(P(tag = 1)) - log(P(tag = 0))) for each category. contingency The contingency function calculates the contingency coefficient, a value that measures the association between two columns in a table. The computation is similar to the cramersV function but with a different denominator in the square root. corr Calculates the Pearson correlation coefficient. corrMatrix Computes the correlation matrix over N variables. corrStable Calculates the Pearson correlation coefficient, but uses a numerically stable algorithm. count Counts the number of rows or not-NULL values. covarPop Calculates the population covariance covarPopMatrix Returns the population covariance matrix over N variables. covarPopStable Calculates the value of the population covariance covarSamp Calculates the value of Σ((x - x̅)(y - y̅)) / (n - 1) covarSampMatrix Returns the sample covariance matrix over N variables. covarSampStable Similar to covarSamp but works slower while providing a lower computational error. cramersV The result of the cramersV function ranges from 0 (corresponding to no association between the variables) to 1 and can reach 1 only when each value is completely determined by the other. It may be viewed as the association between two variables as a percentage of their maximum possible variation. cramersVBiasCorrected Calculates Cramer's V, but uses a bias correction. deltaSum Sums the arithmetic difference between consecutive rows. deltaSumTimestamp Adds the difference between consecutive rows. If the difference is negative, it is ignored. distinctDynamicTypes Calculates the list of distinct data types stored in Dynamic column. distinctJSONPaths Calculates a list of distinct paths stored in a JSON column. distinctJSONPathsAndTypes Calculates the list of distinct paths and their types stored in JSON entropy Calculates Shannon entropy of for a column of values. estimateCompressionRatio Estimates the compression ratio of a given column without compressing it. exponentialMovingAverage Calculates the exponential moving average of values for the determined time. exponentialTimeDecayedAvg Returns the exponentially smoothed weighted moving average of values of a time series at point t in time. exponentialTimeDecayedCount Returns the cumulative exponential decay over a time series at the index t in time. exponentialTimeDecayedMax Returns the maximum of the computed exponentially smoothed moving average at index t in time with that at t-1 . exponentialTimeDecayedSum Returns the sum of exponentially smoothed moving average values of a time series at the index t in time. first_value It is an alias for any but it was introduced for compatibility with Window Functions, where sometimes it is necessary to process NULL values (by default all ClickHouse aggregate functions ignore NULL values). flameGraph Aggregate function which builds a flamegraph using the list of stacktraces. groupArray Creates an array of argument values. Values can be added to the array in any (indeterminate) order. groupArrayArray Aggregates arrays into a larger array of those arrays. groupArrayInsertAt Inserts a value into the array at the specified position. groupArrayIntersect Return an intersection of given arrays (Return all items of arrays, that are in all given arrays). groupArrayLast Creates an array of the last argument values. groupArrayMovingAvg Calculates the moving average of input values. groupArrayMovingSum Calculates the moving sum of input values. groupArraySample Creates an array of sample argument values. The size of the resulting array is limited to max_size elements. Argument values are selected and added to the array randomly. groupArraySorted Returns an array with the first N items in ascending order. groupBitAnd Applies bit-wise AND for series of numbers. groupBitmap Bitmap or Aggregate calculations from a unsigned integer column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object groupBitmapAnd Calculations the AND of a bitmap column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object. groupBitmapOr Calculations the OR of a bitmap column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object. This is equivalent to groupBitmapMerge . groupBitmapXor Calculates the XOR of a bitmap column, and returns the cardinality of type UInt64, if used with suffix -State, then it returns a bitmap object groupBitOr Applies bit-wise OR to a series of numbers. groupBitXor Applies bit-wise XOR for series of numbers. groupConcat Calculates a concatenated string from a group of strings, optionally separated by a delimiter, and optionally limited by a maximum number of elements. groupUniqArray Creates an array from different argument values. intervalLengthSum Calculates the total length of union of all ranges (segments on numeric axis). kolmogorovSmirnovTest Applies Kolmogorov-Smirnov's test to samples from two populations. kurtPop Computes the kurtosis of a sequence. kurtSamp Computes the sample kurtosis of a sequence. largestTriangleThreeBuckets Applies the Largest-Triangle-Three-Buckets algorithm to the input data. last_value Selects the last encountered value, similar to anyLast , but could accept NULL. mannWhitneyUTest Applies the Mann-Whitney rank test to samples from two populations. max Aggregate function that calculates the maximum across a group of values. maxIntersections Aggregate function that calculates the maximum number of times that a group of intervals intersects each other (if all the intervals intersect at least once). maxIntersectionsPosition Aggregate function that calculates the positions of the occurrences of the maxIntersections function. maxMap Calculates the maximum from value array according to the keys specified in the key array. meanZTest Applies mean z-test to samples from two populations. median The median* functions are the aliases for the corresponding quantile* functions. They calculate median of a numeric data sample. min Aggregate function that calculates the minimum across a group of values. minMap Calculates the minimum from value array according to the keys specified in the key array. quantile Computes an approximate quantile of a numeric data sequence. quantileBFloat16 Computes an approximate quantile of a sample consisting of bfloat16 numbers. quantileDD Computes an approximate quantile of a sample with relative-error guarantees. quantileDeterministic Computes an approximate quantile of a numeric data sequence. quantileExact Functions quantileExact, quantileExactLow, quantileExactHigh, quantileExactExclusive, quantileExactInclusive functions quantileExactExclusive Exactly computes the quantile of a numeric data sequence. quantileExactHigh Similar to quantileExact, this computes the exact quantile of a numeric data sequence. quantileExactInclusive Exactly computes the quantile of a numeric data sequence. quantileExactLow Similar to quantileExact, this computes the exact quantile of a numeric data sequence. quantileExactWeighted Exactly computes the quantile of a numeric data sequence, taking into account the weight of each element. quantileExactWeightedInterpolated Computes quantile of a numeric data sequence using linear interpolation, taking into account the weight of each element. quantileGK Computes the quantile of a numeric data sequence using the Greenwald-Khanna algorithm. quantileInterpolatedWeighted Computes quantile of a numeric data sequence using linear interpolation, taking into account the weight of each element. quantilePrometheusHistogram Computes quantile of a histogram using linear interpolation. quantiles Functions quantiles, quantilesExactExclusive, quantilesExactInclusive, quantilesGK quantilesExactExclusive Exactly computes the quantiles of a numeric data sequence. quantilesExactInclusive Exactly computes the quantiles of a numeric data sequence. quantilesGK quantilesGK works similarly to quantileGK but allows us to calculate quantities at different levels simultaneously and returns an array. quantilesTimingWeighted With the determined precision computes the quantile of a numeric data sequence according to the weight of each sequence member. quantileTDigest Computes an approximate quantile of a numeric data sequence using the t-digest algorithm. quantileTDigestWeighted Computes an approximate quantile of a numeric data sequence using the t-digest algorithm. quantileTiming With the determined precision computes the quantile of a numeric data sequence. quantileTimingWeighted With the determined precision computes the quantile of a numeric data sequence according to the weight of each sequence member. rankCorr Computes a rank correlation coefficient. simpleLinearRegression Performs simple (unidimensional) linear regression. singleValueOrNull The aggregate function singleValueOrNull is used to implement subquery operators, such as x = ALL (SELECT ...) . It checks if there is only one unique non-NULL value in the data. skewPop Computes the skewness of a sequence. skewSamp Computes the sample skewness of a sequence. sparkbar The function plots a frequency histogram for values x and the repetition rate y of these values over the interval [min_x, max_x] . stddevPop The result is equal to the square root of varPop. stddevPopStable The result is equal to the square root of varPop. Unlike stddevPop, this function uses a numerically stable algorithm. stddevSamp The result is equal to the square root of varSamp stddevSampStable The result is equal to the square root of varSamp. Unlike this function uses a numerically stable algorithm. stochasticLinearRegression This function implements stochastic linear regression. It supports custom parameters for learning rate, L2 regularization coefficient, mini-batch size, and has a few methods for updating weights (Adam, simple SGD, Momentum, Nesterov.) stochasticLogisticRegression This function implements stochastic logistic regression. It can be used for binary classification problem, supports the same custom parameters as stochasticLinearRegression and works the same way. studentTTest Applies the student t-test to samples from two populations. studentTTestOneSample Applies the one-sample Student t-test to a sample and a known population mean. sum Calculates the sum. Only works for numbers. sumCount Calculates the sum of the numbers and counts the number of rows at the same time. The function is used by ClickHouse query optimizer: if there are multiple sum , count or avg functions in a query, they can be replaced to single sumCount function to reuse the calculations. The function is rarely needed to use explicitly. sumKahan Calculates the sum of the numbers with Kahan compensated summation algorithm sumMap Totals one or more value arrays according to the keys specified in the key array. Returns a tuple of arrays: keys in sorted order, followed by values summed for the corresponding keys without overflow. sumMapWithOverflow Totals a value array according to the keys specified in the key array. Returns a tuple of two arrays: keys in sorted order, and values summed for the corresponding keys. Differs from the sumMap function in that it does summation with overflow. sumWithOverflow Computes the sum of the numbers, using the same data type for the result as for the input parameters. If the sum exceeds the maximum value for this data type, it is calculated with overflow. theilsU The theilsU function calculates Theils' U uncertainty coefficient, a value that measures the association between two columns in a table. timeSeriesChangesToGrid Aggregate function that calculates PromQL-like changes over time series data on the specified grid. timeSeriesDeltaToGrid Aggregate function that calculates PromQL-like delta over time series data on the specified grid. timeSeriesDerivToGrid Aggregate function that calculates PromQL-like derivative over time series data on the specified grid. timeSeriesGroupArray Sorts time series by timestamp in ascending order. timeSeriesInstantDeltaToGrid Aggregate function that calculates PromQL-like idelta over time series data on the specified grid. timeSeriesInstantRateToGrid Aggregate function that calculates PromQL-like irate over time series data on the specified grid. timeSeriesLastTwoSamples Aggregate function for re-sampling time series data for PromQL-like irate and idelta calculation timeSeriesPredictLinearToGrid Aggregate function that calculates PromQL-like linear prediction over time series data on the specified grid. timeSeriesRateToGrid Aggregate function that calculates PromQL-like rate over time series data on the specified grid. timeSeriesResampleToGridWithStaleness Aggregate function that re-samples time series data to the specified grid. timeSeriesResetsToGrid Aggregate function that calculates PromQL-like resets over time series data on the specified grid. topK Returns an array of the approximately most frequent values in the specified column. The resulting array is sorted in descending order of approximate frequency of values (not by the values themselves). topKWeighted Returns an array of the approximately most frequent values in the specified column. The resulting array is sorted in descending order of approximate frequency of values (not by the values themselves). Additionally, the weight of the value is taken into account. uniq Calculates the approximate number of different values of the argument. uniqCombined Calculates the approximate number of different argument values. uniqCombined64 Calculates the approximate number of different argument values. It is the same as uniqCombined, but uses a 64-bit hash for all data types rather than just for the String data type. uniqExact Calculates the exact number of different argument values. uniqHLL12 Calculates the approximate number of different argument values, using the HyperLogLog algorithm. uniqTheta Calculates the approximate number of different argument values, using the Theta Sketch Framework. varPop Calculates the population variance. varPopStable Returns the population variance. Unlike varPop , this function uses a numerically stable algorithm. It works slower but provides a lower computational error. varSamp Calculate the sample variance of a data set. varSampStable Calculate the sample variance of a data set. Unlike varSamp , this function uses a numerically stable algorithm. It works slower but provides a lower computational error. welchTTest Applies Welch's t-test to samples from two populations.
Markdown	[Skip to main content](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference#__docusaurus_skipToContent_fallback) [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) - [Products](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [ClickHouse Cloud Best way to use ClickHouse. Available on AWS, GCP, and Azure.](https://clickhouse.com/cloud) - [BYOC (Bring Your Own Cloud) The fully managed ClickHouse Cloud service, Can be deployed in your AWS account.](https://clickhouse.com/cloud/bring-your-own-cloud) - [ClickHouse Set up a database with open-source ClickHouse. ClickHouse](https://clickhouse.com/clickhouse) - [Discover more than 100 integrations.](https://clickhouse.com/integrations) [Discover more than 100 integrations.](https://clickhouse.com/integrations) - [Use cases](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [Real-time analytics](https://clickhouse.com/use-cases/real-time-analytics) - [Machine Learning & Generative AI](https://clickhouse.com/use-cases/machine-learning-and-data-science) - [Business Intelligence](https://clickhouse.com/use-cases/data-warehousing) - [Logs, Events, Traces](https://clickhouse.com/use-cases/observability) - [All use cases](https://clickhouse.com/use-cases) [All use cases](https://clickhouse.com/use-cases) - [Documentation](https://clickhouse.com/docs) - [Resources](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [User stories](https://clickhouse.com/user-stories) - [Blog](https://clickhouse.com/blog) - [Events](https://clickhouse.com/company/events) - [Learning and certification](https://clickhouse.com/learn) - [Comparison](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Rockset](https://clickhouse.com/comparison/rockset) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Video](https://clickhouse.com/videos) - [Demo](https://clickhouse.com/demos) - [Pricing](https://clickhouse.com/pricing) - [Contact](https://clickhouse.com/company/contact?loc=nav) [46\.7k](https://github.com/ClickHouse/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav) [Search`Ctrl``K`](https://clickhouse.com/docs/search) [Sign in](https://console.clickhouse.cloud/signIn?loc=docs-nav-signIn-cta&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985) [Get started](https://clickhouse.com/docs/introduction-clickhouse) [Cloud](https://clickhouse.com/docs/cloud/overview) [Manage data](https://clickhouse.com/docs/updating-data) [Server admin](https://clickhouse.com/docs/guides/manage-and-deploy-index) [Reference](https://clickhouse.com/docs/sql-reference) [Integrations](https://clickhouse.com/docs/integrations) [ClickStack](https://clickhouse.com/docs/use-cases/observability/clickstack/overview) [chDB](https://clickhouse.com/docs/chdb) [About](https://clickhouse.com/docs/about) [Knowledge Base](https://clickhouse.com/docs/knowledgebase) [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [日本語](https://clickhouse.com/docs/jp/sql-reference/aggregate-functions/reference) - [中文](https://clickhouse.com/docs/zh/sql-reference/aggregate-functions/reference) - [Русский](https://clickhouse.com/docs/ru/sql-reference/aggregate-functions/reference) - [한국어](https://clickhouse.com/docs/ko/sql-reference/aggregate-functions/reference) [Skip to main content](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference#__docusaurus_skipToContent_fallback) [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) - [Products](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [ClickHouse Cloud Best way to use ClickHouse. Available on AWS, GCP, and Azure.](https://clickhouse.com/cloud) - [BYOC (Bring Your Own Cloud) The fully managed ClickHouse Cloud service, Can be deployed in your AWS account.](https://clickhouse.com/cloud/bring-your-own-cloud) - [ClickHouse Set up a database with open-source ClickHouse. ClickHouse](https://clickhouse.com/clickhouse) - [Discover more than 100 integrations.](https://clickhouse.com/integrations) [Discover more than 100 integrations.](https://clickhouse.com/integrations) - [Use cases](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [Real-time analytics](https://clickhouse.com/use-cases/real-time-analytics) - [Machine Learning & Generative AI](https://clickhouse.com/use-cases/machine-learning-and-data-science) - [Business Intelligence](https://clickhouse.com/use-cases/data-warehousing) - [Logs, Events, Traces](https://clickhouse.com/use-cases/observability) - [All use cases](https://clickhouse.com/use-cases) [All use cases](https://clickhouse.com/use-cases) - [Documentation](https://clickhouse.com/docs) - [Resources](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [User stories](https://clickhouse.com/user-stories) - [Blog](https://clickhouse.com/blog) - [Events](https://clickhouse.com/company/events) - [Learning and certification](https://clickhouse.com/learn) - [Comparison](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Rockset](https://clickhouse.com/comparison/rockset) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Video](https://clickhouse.com/videos) - [Demo](https://clickhouse.com/demos) - [Pricing](https://clickhouse.com/pricing) - [Contact](https://clickhouse.com/company/contact?loc=nav) [46\.7k](https://github.com/ClickHouse/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav) [Search`Ctrl``K`](https://clickhouse.com/docs/search) [Sign in](https://console.clickhouse.cloud/signIn?loc=docs-nav-signIn-cta&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985) [Get started](https://clickhouse.com/docs/introduction-clickhouse) [Cloud](https://clickhouse.com/docs/cloud/overview) [Manage data](https://clickhouse.com/docs/updating-data) [Server admin](https://clickhouse.com/docs/guides/manage-and-deploy-index) [Reference](https://clickhouse.com/docs/sql-reference) [Integrations](https://clickhouse.com/docs/integrations) [ClickStack](https://clickhouse.com/docs/use-cases/observability/clickstack/overview) [chDB](https://clickhouse.com/docs/chdb) [About](https://clickhouse.com/docs/about) [Knowledge Base](https://clickhouse.com/docs/knowledgebase) [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [日本語](https://clickhouse.com/docs/jp/sql-reference/aggregate-functions/reference) - [中文](https://clickhouse.com/docs/zh/sql-reference/aggregate-functions/reference) - [Русский](https://clickhouse.com/docs/ru/sql-reference/aggregate-functions/reference) - [한국어](https://clickhouse.com/docs/ko/sql-reference/aggregate-functions/reference) [Search`Ctrl``K`](https://clickhouse.com/docs/search) - [Introduction](https://clickhouse.com/docs/sql-reference) - [Syntax](https://clickhouse.com/docs/sql-reference/syntax) - [Input and Output Formats](https://clickhouse.com/docs/sql-reference/formats) - [Data types](https://clickhouse.com/docs/sql-reference/data-types) - [Statements](https://clickhouse.com/docs/sql-reference/statements) - [Operators](https://clickhouse.com/docs/sql-reference/operators) - [Engines](https://clickhouse.com/docs/engines) - [Database Engines](https://clickhouse.com/docs/engines/database-engines) - [Table Engines](https://clickhouse.com/docs/engines/table-engines) - [Functions](https://clickhouse.com/docs/sql-reference/functions) - [Regular functions](https://clickhouse.com/docs/sql-reference/functions/regular-functions) - [Aggregate functions](https://clickhouse.com/docs/sql-reference/aggregate-functions) - [Aggregate Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [aggThrow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/aggthrow) - [analysisOfVariance](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/analysis_of_variance) - [any](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/any) - [anyHeavy](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/anyheavy) - [anyLast](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/anylast) - [approx\_top\_k](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/approxtopk) - [approx\_top\_sum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/approxtopsum) - [argAndMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argandmax) - [argAndMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argandmin) - [argMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax) - [argMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmin) - [avg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/avg) - [avgWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/avgweighted) - [boundingRatio](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/boundingRatio) - [categoricalInformationValue](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/categoricalinformationvalue) - [contingency](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/contingency) - [corr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corr) - [corrMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corrmatrix) - [corrStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corrstable) - [count](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/count) - [covarPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpop) - [covarPopMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpopmatrix) - [covarPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpopstable) - [covarSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsamp) - [covarSampMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsampmatrix) - [covarSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsampstable) - [cramersV](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/cramersv) - [cramersVBiasCorrected](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/cramersvbiascorrected) - [deltaSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/deltasum) - [deltaSumTimestamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/deltasumtimestamp) - [distinctDynamicTypes](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctdynamictypes) - [distinctJSONPaths](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctjsonpaths) - [distinctJSONPathsAndTypes](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctJSONPathsAndTypes) - [entropy](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/entropy) - [estimateCompressionRatio](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/estimateCompressionRatio) - [exponentialMovingAverage](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialMovingAverage) - [exponentialTimeDecayedAvg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedAvg) - [exponentialTimeDecayedCount](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedCount) - [exponentialTimeDecayedMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedMax) - [exponentialTimeDecayedSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedSum) - [first\_value](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value) - [flameGraph](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/flame_graph) - [groupArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparray) - [groupArrayArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayarray) - [groupArrayInsertAt](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayinsertat) - [groupArrayIntersect](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayintersect) - [groupArrayLast](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraylast) - [groupArrayMovingAvg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraymovingavg) - [groupArrayMovingSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraymovingsum) - [groupArraySample](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraysample) - [groupArraySorted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraysorted) - [groupBitAnd](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitand) - [groupBitOr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitor) - [groupBitXor](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitxor) - [groupBitmap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) - [groupBitmapAnd](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapand) - [groupBitmapOr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapor) - [groupBitmapXor](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapxor) - [groupConcat](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupconcat) - [groupUniqArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupuniqarray) - [intervalLengthSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/intervalLengthSum) - [kolmogorovSmirnovTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kolmogorovsmirnovtest) - [kurtPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kurtpop) - [kurtSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kurtsamp) - [largestTriangleThreeBuckets](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/largestTriangleThreeBuckets) - [last\_value](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/last_value) - [mannWhitneyUTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/mannwhitneyutest) - [max](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/max) - [maxIntersections](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxintersections) - [maxIntersectionsPosition](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxintersectionsposition) - [maxMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxmap) - [meanZTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/meanztest) - [median](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/median) - [min](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/min) - [minMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/minmap) - [quantile](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantile) - [quantileBFloat16](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilebfloat16) - [quantileDD](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileddsketch) - [quantileDeterministic](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiledeterministic) - [quantileExact Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileexact) - [quantileExactExclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactExclusive) - [quantileExactHigh](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactHigh) - [quantileExactInclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactInclusive) - [quantileExactLow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactLow) - [quantileExactWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileexactweighted) - [quantileExactWeightedInterpolated](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactWeightedInterpolated) - [quantileGK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileGK) - [quantileInterpolatedWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileInterpolatedWeighted) - [quantilePrometheusHistogram](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilePrometheusHistogram) - [quantileTDigest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletdigest) - [quantileTDigestWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletdigestweighted) - [quantileTiming](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletiming) - [quantileTimingWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletimingweighted) - [quantiles Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiles) - [quantilesExactExclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesExactExclusive) - [quantilesExactInclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesExactInclusive) - [quantilesGK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesGK) - [quantilesTimingWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilestimingweighted) - [rankCorr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/rankCorr) - [simpleLinearRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/simplelinearregression) - [singleValueOrNull](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/singlevalueornull) - [skewPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/skewpop) - [skewSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/skewsamp) - [sparkbar](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sparkbar) - [stddevPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevpop) - [stddevPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevpopstable) - [stddevSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevsamp) - [stddevSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevsampstable) - [stochasticLinearRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stochasticlinearregression) - [stochasticLogisticRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stochasticlogisticregression) - [studentTTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/studentttest) - [studentTTestOneSample](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/studentttestonesample) - [sum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sum) - [sumCount](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumcount) - [sumKahan](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumkahan) - [sumMapWithOverflow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/summapwithoverflow) - [sumMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/summap) - [sumWithOverflow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumwithoverflow) - [theilsU](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/theilsu) - [timeSeriesChangesToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesChangesToGrid) - [timeSeriesDeltaToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesDeltaToGrid) - [timeSeriesDerivToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesDerivToGrid) - [timeSeriesGroupArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesGroupArray) - [timeSeriesInstantDeltaToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesInstantDeltaToGrid) - [timeSeriesInstantRateToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesInstantRateToGrid) - [timeSeriesLastTwoSamples](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesLastTwoSamples) - [timeSeriesPredictLinearToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesPredictLinearToGrid) - [timeSeriesRateToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesRateToGrid) - [timeSeriesResampleToGridWithStaleness](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesResampleToGridWithStaleness) - [timeSeriesResetsToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesResetsToGrid) - [topK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/topk) - [topKWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/topkweighted) - [uniq](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniq) - [uniqCombined](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqcombined) - [uniqCombined64](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqcombined64) - [uniqExact](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqexact) - [uniqHLL12](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqhll12) - [uniqTheta](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqthetasketch) - [varPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varPop) - [varPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varpopstable) - [varSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varSamp) - [varSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varsampstable) - [welchTTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/welchttest) - [Combinators](https://clickhouse.com/docs/sql-reference/aggregate-functions/combinators) - [Parametric](https://clickhouse.com/docs/sql-reference/aggregate-functions/parametric-functions) - [GROUPING](https://clickhouse.com/docs/sql-reference/aggregate-functions/grouping_function) - [Combinator examples](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - [Table functions](https://clickhouse.com/docs/sql-reference/table-functions) - [Window functions](https://clickhouse.com/docs/sql-reference/window-functions) - [Formats](https://clickhouse.com/docs/interfaces/formats) - [Data Lakes](https://clickhouse.com/docs/sql-reference/datalakes) - [Functions](https://clickhouse.com/docs/sql-reference/functions) - [Aggregate functions](https://clickhouse.com/docs/sql-reference/aggregate-functions) - Aggregate Functions [Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/sql-reference/aggregate-functions/reference/index.md) # Aggregate functions ClickHouse supports all standard SQL aggregate functions ([sum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sum), [avg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/avg), [min](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/min), [max](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/max), [count](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/count)), as well as a wide range of other aggregate functions. \| Page \| Description \| \|---\|---\| \| [aggThrow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/aggthrow) \| This function can be used for the purpose of testing exception safety. It will throw an exception on creation with the specified probability. \| \| [analysisOfVariance](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/analysis_of_variance) \| Provides a statistical test for one-way analysis of variance (ANOVA test). It is a test over several groups of normally distributed observations to find out whether all groups have the same mean or not. \| \| [any](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/any) \| Selects the first encountered value of a column. \| \| [anyHeavy](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/anyheavy) \| Selects a frequently occurring value using the heavy hitters algorithm. If there is a value that occurs more than in half the cases in each of the query execution threads, this value is returned. Normally, the result is nondeterministic. \| \| [anyLast](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/anylast) \| Selects the last encountered value of a column. \| \| [approx\_top\_k](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/approxtopk) \| Returns an array of the approximately most frequent values and their counts in the specified column. \| \| [approx\_top\_sum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/approxtopsum) \| Returns an array of the approximately most frequent values and their counts in the specified column. \| \| [argAndMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argandmax) \| Calculates the `arg` and `val` value for a maximum `val` value. If there are multiple rows with equal `val` being the maximum, which of the associated `arg` and `val` is returned is not deterministic. \| \| [argAndMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argandmin) \| Calculates the `arg` and `val` value for a minimum `val` value. If there are multiple rows with equal `val` being the minimum, which of the associated `arg` and `val` is returned is not deterministic. \| \| [argMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax) \| Calculates the `arg` value for a maximum `val` value. \| \| [argMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmin) \| Calculates the `arg` value for a minimum `val` value. If there are multiple rows with equal `val` being the maximum, which of the associated `arg` is returned is not deterministic. \| \| [avg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/avg) \| Calculates the arithmetic mean. \| \| [avgWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/avgweighted) \| Calculates the weighted arithmetic mean. \| \| [boundingRatio](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/boundingRatio) \| Aggregate function that calculates the slope between the leftmost and rightmost points across a group of values. \| \| [categoricalInformationValue](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/categoricalinformationvalue) \| Calculates the value of `(P(tag = 1) - P(tag = 0))(log(P(tag = 1)) - log(P(tag = 0)))` for each category. \| \| [contingency](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/contingency) \| The `contingency` function calculates the contingency coefficient, a value that measures the association between two columns in a table. The computation is similar to the `cramersV` function but with a different denominator in the square root. \| \| [corr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corr) \| Calculates the Pearson correlation coefficient. \| \| [corrMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corrmatrix) \| Computes the correlation matrix over N variables. \| \| [corrStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/corrstable) \| Calculates the Pearson correlation coefficient, but uses a numerically stable algorithm. \| \| [count](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/count) \| Counts the number of rows or not-NULL values. \| \| [covarPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpop) \| Calculates the population covariance \| \| [covarPopMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpopmatrix) \| Returns the population covariance matrix over N variables. \| \| [covarPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarpopstable) \| Calculates the value of the population covariance \| \| [covarSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsamp) \| Calculates the value of `Σ((x - x̅)(y - y̅)) / (n - 1)` \| \| [covarSampMatrix](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsampmatrix) \| Returns the sample covariance matrix over N variables. \| \| [covarSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/covarsampstable) \| Similar to covarSamp but works slower while providing a lower computational error. \| \| [cramersV](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/cramersv) \| The result of the `cramersV` function ranges from 0 (corresponding to no association between the variables) to 1 and can reach 1 only when each value is completely determined by the other. It may be viewed as the association between two variables as a percentage of their maximum possible variation. \| \| [cramersVBiasCorrected](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/cramersvbiascorrected) \| Calculates Cramer's V, but uses a bias correction. \| \| [deltaSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/deltasum) \| Sums the arithmetic difference between consecutive rows. \| \| [deltaSumTimestamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/deltasumtimestamp) \| Adds the difference between consecutive rows. If the difference is negative, it is ignored. \| \| [distinctDynamicTypes](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctdynamictypes) \| Calculates the list of distinct data types stored in Dynamic column. \| \| [distinctJSONPaths](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctjsonpaths) \| Calculates a list of distinct paths stored in a JSON column. \| \| [distinctJSONPathsAndTypes](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/distinctJSONPathsAndTypes) \| Calculates the list of distinct paths and their types stored in JSON \| \| [entropy](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/entropy) \| Calculates Shannon entropy of for a column of values. \| \| [estimateCompressionRatio](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/estimateCompressionRatio) \| Estimates the compression ratio of a given column without compressing it. \| \| [exponentialMovingAverage](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialMovingAverage) \| Calculates the exponential moving average of values for the determined time. \| \| [exponentialTimeDecayedAvg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedAvg) \| Returns the exponentially smoothed weighted moving average of values of a time series at point `t` in time. \| \| [exponentialTimeDecayedCount](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedCount) \| Returns the cumulative exponential decay over a time series at the index `t` in time. \| \| [exponentialTimeDecayedMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedMax) \| Returns the maximum of the computed exponentially smoothed moving average at index `t` in time with that at `t-1`. \| \| [exponentialTimeDecayedSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedSum) \| Returns the sum of exponentially smoothed moving average values of a time series at the index `t` in time. \| \| [first\_value](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value) \| It is an alias for any but it was introduced for compatibility with Window Functions, where sometimes it is necessary to process `NULL` values (by default all ClickHouse aggregate functions ignore NULL values). \| \| [flameGraph](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/flame_graph) \| Aggregate function which builds a flamegraph using the list of stacktraces. \| \| [groupArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparray) \| Creates an array of argument values. Values can be added to the array in any (indeterminate) order. \| \| [groupArrayArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayarray) \| Aggregates arrays into a larger array of those arrays. \| \| [groupArrayInsertAt](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayinsertat) \| Inserts a value into the array at the specified position. \| \| [groupArrayIntersect](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparrayintersect) \| Return an intersection of given arrays (Return all items of arrays, that are in all given arrays). \| \| [groupArrayLast](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraylast) \| Creates an array of the last argument values. \| \| [groupArrayMovingAvg](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraymovingavg) \| Calculates the moving average of input values. \| \| [groupArrayMovingSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraymovingsum) \| Calculates the moving sum of input values. \| \| [groupArraySample](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraysample) \| Creates an array of sample argument values. The size of the resulting array is limited to `max_size` elements. Argument values are selected and added to the array randomly. \| \| [groupArraySorted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/grouparraysorted) \| Returns an array with the first N items in ascending order. \| \| [groupBitAnd](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitand) \| Applies bit-wise `AND` for series of numbers. \| \| [groupBitmap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmap) \| Bitmap or Aggregate calculations from a unsigned integer column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object \| \| [groupBitmapAnd](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapand) \| Calculations the AND of a bitmap column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object. \| \| [groupBitmapOr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapor) \| Calculations the OR of a bitmap column, return cardinality of type UInt64, if add suffix -State, then return a bitmap object. This is equivalent to `groupBitmapMerge`. \| \| [groupBitmapXor](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitmapxor) \| Calculates the XOR of a bitmap column, and returns the cardinality of type UInt64, if used with suffix -State, then it returns a bitmap object \| \| [groupBitOr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitor) \| Applies bit-wise `OR` to a series of numbers. \| \| [groupBitXor](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupbitxor) \| Applies bit-wise `XOR` for series of numbers. \| \| [groupConcat](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupconcat) \| Calculates a concatenated string from a group of strings, optionally separated by a delimiter, and optionally limited by a maximum number of elements. \| \| [groupUniqArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/groupuniqarray) \| Creates an array from different argument values. \| \| [intervalLengthSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/intervalLengthSum) \| Calculates the total length of union of all ranges (segments on numeric axis). \| \| [kolmogorovSmirnovTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kolmogorovsmirnovtest) \| Applies Kolmogorov-Smirnov's test to samples from two populations. \| \| [kurtPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kurtpop) \| Computes the kurtosis of a sequence. \| \| [kurtSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/kurtsamp) \| Computes the sample kurtosis of a sequence. \| \| [largestTriangleThreeBuckets](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/largestTriangleThreeBuckets) \| Applies the Largest-Triangle-Three-Buckets algorithm to the input data. \| \| [last\_value](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/last_value) \| Selects the last encountered value, similar to `anyLast`, but could accept NULL. \| \| [mannWhitneyUTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/mannwhitneyutest) \| Applies the Mann-Whitney rank test to samples from two populations. \| \| [max](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/max) \| Aggregate function that calculates the maximum across a group of values. \| \| [maxIntersections](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxintersections) \| Aggregate function that calculates the maximum number of times that a group of intervals intersects each other (if all the intervals intersect at least once). \| \| [maxIntersectionsPosition](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxintersectionsposition) \| Aggregate function that calculates the positions of the occurrences of the maxIntersections function. \| \| [maxMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/maxmap) \| Calculates the maximum from `value` array according to the keys specified in the `key` array. \| \| [meanZTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/meanztest) \| Applies mean z-test to samples from two populations. \| \| [median](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/median) \| The `median` functions are the aliases for the corresponding `quantile` functions. They calculate median of a numeric data sample. \| \| [min](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/min) \| Aggregate function that calculates the minimum across a group of values. \| \| [minMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/minmap) \| Calculates the minimum from `value` array according to the keys specified in the `key` array. \| \| [quantile](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantile) \| Computes an approximate quantile of a numeric data sequence. \| \| [quantileBFloat16](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilebfloat16) \| Computes an approximate quantile of a sample consisting of bfloat16 numbers. \| \| [quantileDD](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileddsketch) \| Computes an approximate quantile of a sample with relative-error guarantees. \| \| [quantileDeterministic](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiledeterministic) \| Computes an approximate quantile of a numeric data sequence. \| \| [quantileExact Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileexact) \| quantileExact, quantileExactLow, quantileExactHigh, quantileExactExclusive, quantileExactInclusive functions \| \| [quantileExactExclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactExclusive) \| Exactly computes the quantile of a numeric data sequence. \| \| [quantileExactHigh](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactHigh) \| Similar to quantileExact, this computes the exact quantile of a numeric data sequence. \| \| [quantileExactInclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactInclusive) \| Exactly computes the quantile of a numeric data sequence. \| \| [quantileExactLow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactLow) \| Similar to quantileExact, this computes the exact [quantile](https://en.wikipedia.org/wiki/Quantile) of a numeric data sequence. \| \| [quantileExactWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileexactweighted) \| Exactly computes the quantile of a numeric data sequence, taking into account the weight of each element. \| \| [quantileExactWeightedInterpolated](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileExactWeightedInterpolated) \| Computes quantile of a numeric data sequence using linear interpolation, taking into account the weight of each element. \| \| [quantileGK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileGK) \| Computes the quantile of a numeric data sequence using the Greenwald-Khanna algorithm. \| \| [quantileInterpolatedWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantileInterpolatedWeighted) \| Computes quantile of a numeric data sequence using linear interpolation, taking into account the weight of each element. \| \| [quantilePrometheusHistogram](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilePrometheusHistogram) \| Computes quantile of a histogram using linear interpolation. \| \| [quantiles Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiles) \| quantiles, quantilesExactExclusive, quantilesExactInclusive, quantilesGK \| \| [quantilesExactExclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesExactExclusive) \| Exactly computes the quantiles of a numeric data sequence. \| \| [quantilesExactInclusive](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesExactInclusive) \| Exactly computes the quantiles of a numeric data sequence. \| \| [quantilesGK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilesGK) \| quantilesGK works similarly to quantileGK but allows us to calculate quantities at different levels simultaneously and returns an array. \| \| [quantilesTimingWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantilestimingweighted) \| With the determined precision computes the quantile of a numeric data sequence according to the weight of each sequence member. \| \| [quantileTDigest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletdigest) \| Computes an approximate quantile of a numeric data sequence using the t-digest algorithm. \| \| [quantileTDigestWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletdigestweighted) \| Computes an approximate quantile of a numeric data sequence using the t-digest algorithm. \| \| [quantileTiming](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletiming) \| With the determined precision computes the quantile of a numeric data sequence. \| \| [quantileTimingWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/quantiletimingweighted) \| With the determined precision computes the quantile of a numeric data sequence according to the weight of each sequence member. \| \| [rankCorr](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/rankCorr) \| Computes a rank correlation coefficient. \| \| [simpleLinearRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/simplelinearregression) \| Performs simple (unidimensional) linear regression. \| \| [singleValueOrNull](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/singlevalueornull) \| The aggregate function `singleValueOrNull` is used to implement subquery operators, such as `x = ALL (SELECT ...)`. It checks if there is only one unique non-NULL value in the data. \| \| [skewPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/skewpop) \| Computes the skewness of a sequence. \| \| [skewSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/skewsamp) \| Computes the sample skewness of a sequence. \| \| [sparkbar](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sparkbar) \| The function plots a frequency histogram for values `x` and the repetition rate `y` of these values over the interval `[min_x, max_x]`. \| \| [stddevPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevpop) \| The result is equal to the square root of varPop. \| \| [stddevPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevpopstable) \| The result is equal to the square root of varPop. Unlike stddevPop, this function uses a numerically stable algorithm. \| \| [stddevSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevsamp) \| The result is equal to the square root of varSamp \| \| [stddevSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stddevsampstable) \| The result is equal to the square root of varSamp. Unlike this function uses a numerically stable algorithm. \| \| [stochasticLinearRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stochasticlinearregression) \| This function implements stochastic linear regression. It supports custom parameters for learning rate, L2 regularization coefficient, mini-batch size, and has a few methods for updating weights (Adam, simple SGD, Momentum, Nesterov.) \| \| [stochasticLogisticRegression](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/stochasticlogisticregression) \| This function implements stochastic logistic regression. It can be used for binary classification problem, supports the same custom parameters as stochasticLinearRegression and works the same way. \| \| [studentTTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/studentttest) \| Applies the student t-test to samples from two populations. \| \| [studentTTestOneSample](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/studentttestonesample) \| Applies the one-sample Student t-test to a sample and a known population mean. \| \| [sum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sum) \| Calculates the sum. Only works for numbers. \| \| [sumCount](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumcount) \| Calculates the sum of the numbers and counts the number of rows at the same time. The function is used by ClickHouse query optimizer: if there are multiple `sum`, `count` or `avg` functions in a query, they can be replaced to single `sumCount` function to reuse the calculations. The function is rarely needed to use explicitly. \| \| [sumKahan](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumkahan) \| Calculates the sum of the numbers with Kahan compensated summation algorithm \| \| [sumMap](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/summap) \| Totals one or more `value` arrays according to the keys specified in the `key` array. Returns a tuple of arrays: keys in sorted order, followed by values summed for the corresponding keys without overflow. \| \| [sumMapWithOverflow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/summapwithoverflow) \| Totals a `value` array according to the keys specified in the `key` array. Returns a tuple of two arrays: keys in sorted order, and values summed for the corresponding keys. Differs from the sumMap function in that it does summation with overflow. \| \| [sumWithOverflow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/sumwithoverflow) \| Computes the sum of the numbers, using the same data type for the result as for the input parameters. If the sum exceeds the maximum value for this data type, it is calculated with overflow. \| \| [theilsU](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/theilsu) \| The `theilsU` function calculates Theils' U uncertainty coefficient, a value that measures the association between two columns in a table. \| \| [timeSeriesChangesToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesChangesToGrid) \| Aggregate function that calculates PromQL-like changes over time series data on the specified grid. \| \| [timeSeriesDeltaToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesDeltaToGrid) \| Aggregate function that calculates PromQL-like delta over time series data on the specified grid. \| \| [timeSeriesDerivToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesDerivToGrid) \| Aggregate function that calculates PromQL-like derivative over time series data on the specified grid. \| \| [timeSeriesGroupArray](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesGroupArray) \| Sorts time series by timestamp in ascending order. \| \| [timeSeriesInstantDeltaToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesInstantDeltaToGrid) \| Aggregate function that calculates PromQL-like idelta over time series data on the specified grid. \| \| [timeSeriesInstantRateToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesInstantRateToGrid) \| Aggregate function that calculates PromQL-like irate over time series data on the specified grid. \| \| [timeSeriesLastTwoSamples](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesLastTwoSamples) \| Aggregate function for re-sampling time series data for PromQL-like irate and idelta calculation \| \| [timeSeriesPredictLinearToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesPredictLinearToGrid) \| Aggregate function that calculates PromQL-like linear prediction over time series data on the specified grid. \| \| [timeSeriesRateToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesRateToGrid) \| Aggregate function that calculates PromQL-like rate over time series data on the specified grid. \| \| [timeSeriesResampleToGridWithStaleness](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesResampleToGridWithStaleness) \| Aggregate function that re-samples time series data to the specified grid. \| \| [timeSeriesResetsToGrid](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/timeSeriesResetsToGrid) \| Aggregate function that calculates PromQL-like resets over time series data on the specified grid. \| \| [topK](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/topk) \| Returns an array of the approximately most frequent values in the specified column. The resulting array is sorted in descending order of approximate frequency of values (not by the values themselves). \| \| [topKWeighted](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/topkweighted) \| Returns an array of the approximately most frequent values in the specified column. The resulting array is sorted in descending order of approximate frequency of values (not by the values themselves). Additionally, the weight of the value is taken into account. \| \| [uniq](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniq) \| Calculates the approximate number of different values of the argument. \| \| [uniqCombined](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqcombined) \| Calculates the approximate number of different argument values. \| \| [uniqCombined64](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqcombined64) \| Calculates the approximate number of different argument values. It is the same as uniqCombined, but uses a 64-bit hash for all data types rather than just for the String data type. \| \| [uniqExact](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqexact) \| Calculates the exact number of different argument values. \| \| [uniqHLL12](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqhll12) \| Calculates the approximate number of different argument values, using the HyperLogLog algorithm. \| \| [uniqTheta](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/uniqthetasketch) \| Calculates the approximate number of different argument values, using the Theta Sketch Framework. \| \| [varPop](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varPop) \| Calculates the population variance. \| \| [varPopStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varpopstable) \| Returns the population variance. Unlike varPop , this function uses a numerically stable algorithm. It works slower but provides a lower computational error. \| \| [varSamp](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varSamp) \| Calculate the sample variance of a data set. \| \| [varSampStable](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/varsampstable) \| Calculate the sample variance of a data set. Unlike `varSamp` , this function uses a numerically stable algorithm. It works slower but provides a lower computational error. \| \| [welchTTest](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/welchttest) \| Applies Welch's t-test to samples from two populations. \| [Previous Aggregate Functions](https://clickhouse.com/docs/sql-reference/aggregate-functions) [Next aggThrow](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/aggthrow) Was this page helpful? ###### Try ClickHouse Cloud for FREE Separation of storage and compute, automatic scaling, built-in SQL console, and lots more. \$300 in free credits when signing up. [Try it for Free](https://console.clickhouse.cloud/signUp?loc=doc-card-banner&glxid=f3d9dfaf-92f3-4b93-8269-13da799d3f21&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference&utm_ga=GA1.1.1011770293.1775246985) © 2016–2026 ClickHouse, Inc. [Trademark](https://clickhouse.com/legal/trademark-policy)·[Privacy](https://clickhouse.com/legal/privacy-policy)·[Security](https://trust.clickhouse.com/)·[Terms of Service](https://clickhouse.com/legal/agreements/terms-of-service) ![](https://static.scarf.sh/a.png?x-pxid=e6377503-591b-4886-9398-e69c7fee0b91) © 2016–2026 ClickHouse, Inc. [Trademark](https://clickhouse.com/legal/trademark-policy)·[Privacy](https://clickhouse.com/legal/privacy-policy)·[Security](https://trust.clickhouse.com/)·[Terms of Service](https://clickhouse.com/legal/agreements/terms-of-service) ![](https://static.scarf.sh/a.png?x-pxid=e6377503-591b-4886-9398-e69c7fee0b91) [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) EN - Get started▼ - Cloud▼ - Manage data▼ - Server admin▼ - Reference▼ - Integrations▼ - ClickStack▼ - chDB▼ - About▼ [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) EN main-menu - Introduction▼ - [Syntax](https://clickhouse.com/docs/sql-reference/syntax) - [Input and Output Formats](https://clickhouse.com/docs/sql-reference/formats) - Data types▼ - Statements▼ - Operators▼ - Engines▼ - Functions▼ - Formats▼ - [Data Lakes](https://clickhouse.com/docs/sql-reference/datalakes)
Readable Markdown	null
Shard	89 (laksa)
Root Hash	12633450985039531489
Unparsed URL	com,clickhouse!/docs/sql-reference/aggregate-functions/reference s443