🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 89 (from laksa100)

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/argmax\')), getAhrefsUnparsedNoserviceFromURL(\'https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax\'))) FORMAT JSONEachRow'

Response:

{"found_url":"https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax","crawl_time":1775696723,"first_indexed_time":1740519665,"http_code":200,"src_unparsed":"com,clickhouse!\/docs\/sql-reference\/aggregate-functions\/reference\/argmax s443","src_root_hash":"12633450985039531489","history_drop_reason":null,"meta_title":"argMax | ClickHouse Docs","meta_descriptions":["Calculates the `arg` value for a maximum `val` value."],"attrs_boilerpipe_text":"argMax\n\nIntroduced in: v1.1.0\nCalculates the\narg\nvalue for a maximum\nval\nvalue. If there are multiple rows with equal\nval\nbeing the maximum, which of the associated\narg\nis returned is not deterministic.\nBoth parts the\narg\nand the\nmax\nbehave as\naggregate functions\n, they both\nskip\nNull\nduring processing and return not\nNull\nvalues if not\nNull\nvalues are available.\nSee also\nTuple\nSyntax\nargMax\n(\narg\n,\nval\n)\nArguments\narg\n— Argument for which to find the maximum value.\nconst String\nval\n— The maximum value.\n(U)Int8\/16\/32\/64\nor\nFloat*\nor\nDate\nor\nDateTime\nor\nTuple\nReturned value\nReturns the\narg\nvalue that corresponds to maximum\nval\nvalue. Type matches\narg\ntype.\nExamples\nBasic usage\nQuery\nSELECT\nargMax\n(\nuser\n,\nsalary\n)\nFROM\nsalary\n;\nResponse\n┌─argMax(user, salary)─┐\n│ director             │\n└──────────────────────┘\nExtended example with NULL handling\nQuery\nCREATE\nTABLE\ntest\n(\na Nullable\n(\nString\n)\n,\nb Nullable\n(\nInt64\n)\n)\nENGINE\n=\nMemory\nAS\nSELECT\n*\nFROM\nVALUES\n(\n(\n'a'\n,\n1\n)\n,\n(\n'b'\n,\n2\n)\n,\n(\n'c'\n,\n2\n)\n,\n(\nNULL\n,\n3\n)\n,\n(\nNULL\n,\nNULL\n)\n,\n(\n'd'\n,\nNULL\n)\n)\n;\nSELECT\nargMax\n(\na\n,\nb\n)\n,\nmax\n(\nb\n)\nFROM\ntest\n;\nResponse\n┌─argMax(a, b)─┬─max(b)─┐\n│ b            │      3 │\n└──────────────┴────────┘\nUsing Tuple in arguments\nQuery\nSELECT\nargMax\n(\na\n,\n(\nb\n,\na\n)\n)\nFROM\ntest\n;\nResponse\n┌─argMax(a, tuple(b, a))─┐\n│ c                      │\n└────────────────────────┘","attrs_markdown":"[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax#__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\/argmax)\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\/argmax)\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\/argmax)\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\/argmax)\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\\.8k](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=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725)\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\/argmax)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/aggregate-functions\/reference\/argmax)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/aggregate-functions\/reference\/argmax)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/aggregate-functions\/reference\/argmax)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/aggregate-functions\/reference\/argmax)\n\n[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax#__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\/argmax)\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\/argmax)\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\/argmax)\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\/argmax)\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\\.8k](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=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725)\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\/argmax)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/aggregate-functions\/reference\/argmax)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/aggregate-functions\/reference\/argmax)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/aggregate-functions\/reference\/argmax)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/aggregate-functions\/reference\/argmax)\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\/argmax)\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](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference)\n- argMax\n\n[Edit this page](https:\/\/github.com\/ClickHouse\/ClickHouse\/tree\/master\/docs\/en\/sql-reference\/aggregate-functions\/reference\/argMax.md)\n\n# argMax\n## argMax[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax#argMax \"Direct link to argMax\")\nIntroduced in: v1.1.0\n\nCalculates the `arg` value for a maximum `val` value. If there are multiple rows with equal `val` being the maximum, which of the associated `arg` is returned is not deterministic. Both parts the `arg` and the `max` behave as [aggregate functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions), they both [skip `Null`](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions#null-processing) during processing and return not `Null` values if not `Null` values are available.\n\n**See also**\n\n- [Tuple](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/tuple)\n\n**Syntax**\n```\nargMax(arg, val)\n```\n**Arguments**\n\n- `arg` — Argument for which to find the maximum value. [`const String`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/string)\n- `val` — The maximum value. [`(U)Int8\/16\/32\/64`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/int-uint) or [`Float*`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/float) or [`Date`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/date) or [`DateTime`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/datetime) or [`Tuple`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/tuple)\n\n**Returned value**\n\nReturns the `arg` value that corresponds to maximum `val` value. Type matches `arg` type.\n\n**Examples**\n\n**Basic usage**\n\nQuery\n```\nSELECT argMax(user, salary) FROM salary;\n```\n\nResponse\n```\n┌─argMax(user, salary)─┐\n│ director             │\n└──────────────────────┘\n```\n\n**Extended example with NULL handling**\n\nQuery\n```\nCREATE TABLE test\n(\n    a Nullable(String),\n    b Nullable(Int64)\n)\nENGINE = Memory AS\nSELECT *\nFROM VALUES(('a', 1), ('b', 2), ('c', 2), (NULL, 3), (NULL, NULL), ('d', NULL));\n\nSELECT argMax(a, b), max(b) FROM test;\n```\n\nResponse\n```\n┌─argMax(a, b)─┬─max(b)─┐\n│ b            │      3 │\n└──────────────┴────────┘\n```\n\n**Using Tuple in arguments**\n\nQuery\n```\nSELECT argMax(a, (b,a)) FROM test;\n```\n\nResponse\n```\n┌─argMax(a, tuple(b, a))─┐\n│ c                      │\n└────────────────────────┘\n```\n\n[Previous argAndMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argandmin)\n\n[Next argMin](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmin)\n\n- [argMax](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax#argMax)\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=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725)\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  - Regular functions▼\n  - Aggregate functions▼\n    - Aggregate Functions▼\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▼\n  - Table functions▼\n  - Window functions▼\n- Formats▼\n- [Data Lakes](https:\/\/clickhouse.com\/docs\/sql-reference\/datalakes)","attrs_readable_markdown":"## argMax[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/argmax#argMax \"Direct link to argMax\")\nIntroduced in: v1.1.0\n\nCalculates the `arg` value for a maximum `val` value. If there are multiple rows with equal `val` being the maximum, which of the associated `arg` is returned is not deterministic. Both parts the `arg` and the `max` behave as [aggregate functions](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions), they both [skip `Null`](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions#null-processing) during processing and return not `Null` values if not `Null` values are available.\n\n**See also**\n\n- [Tuple](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/tuple)\n\n**Syntax**\n```\nargMax(arg, val)\n```\n**Arguments**\n\n- `arg` — Argument for which to find the maximum value. [`const String`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/string)\n- `val` — The maximum value. [`(U)Int8\/16\/32\/64`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/int-uint) or [`Float*`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/float) or [`Date`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/date) or [`DateTime`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/datetime) or [`Tuple`](https:\/\/clickhouse.com\/docs\/sql-reference\/data-types\/tuple)\n\n**Returned value**\n\nReturns the `arg` value that corresponds to maximum `val` value. Type matches `arg` type.\n\n**Examples**\n\n**Basic usage**\n\nQuery\n```\nSELECT argMax(user, salary) FROM salary;\n```\n\nResponse\n```\n┌─argMax(user, salary)─┐\n│ director             │\n└──────────────────────┘\n```\n\n**Extended example with NULL handling**\n\nQuery\n```\nCREATE TABLE test\n(\n    a Nullable(String),\n    b Nullable(Int64)\n)\nENGINE = Memory AS\nSELECT *\nFROM VALUES(('a', 1), ('b', 2), ('c', 2), (NULL, 3), (NULL, NULL), ('d', NULL));\n\nSELECT argMax(a, b), max(b) FROM test;\n```\n\nResponse\n```\n┌─argMax(a, b)─┬─max(b)─┐\n│ b            │      3 │\n└──────────────┴────────┘\n```\n\n**Using Tuple in arguments**\n\nQuery\n```\nSELECT argMax(a, (b,a)) FROM test;\n```\n\nResponse\n```\n┌─argMax(a, tuple(b, a))─┐\n│ c                      │\n└────────────────────────┘\n```","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

1 day 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 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/argmax
Last Crawled	2026-04-09 01:05:23 (1 day ago)
First Indexed	2025-02-25 21:41:05 (1 year ago)
HTTP Status Code	200
Meta Title	argMax \| ClickHouse Docs
Meta Description	Calculates the `arg` value for a maximum `val` value.
Meta Canonical	null
Boilerpipe Text	argMax Introduced in: v1.1.0 Calculates the arg value for a maximum val value. If there are multiple rows with equal val being the maximum, which of the associated arg is returned is not deterministic. Both parts the arg and the max behave as aggregate functions , they both skip Null during processing and return not Null values if not Null values are available. See also Tuple Syntax argMax ( arg , val ) Arguments arg — Argument for which to find the maximum value. const String val — The maximum value. (U)Int8/16/32/64 or Float* or Date or DateTime or Tuple Returned value Returns the arg value that corresponds to maximum val value. Type matches arg type. Examples Basic usage Query SELECT argMax ( user , salary ) FROM salary ; Response ┌─argMax(user, salary)─┐ │ director │ └──────────────────────┘ Extended example with NULL handling Query CREATE TABLE test ( a Nullable ( String ) , b Nullable ( Int64 ) ) ENGINE = Memory AS SELECT * FROM VALUES ( ( 'a' , 1 ) , ( 'b' , 2 ) , ( 'c' , 2 ) , ( NULL , 3 ) , ( NULL , NULL ) , ( 'd' , NULL ) ) ; SELECT argMax ( a , b ) , max ( b ) FROM test ; Response ┌─argMax(a, b)─┬─max(b)─┐ │ b │ 3 │ └──────────────┴────────┘ Using Tuple in arguments Query SELECT argMax ( a , ( b , a ) ) FROM test ; Response ┌─argMax(a, tuple(b, a))─┐ │ c │ └────────────────────────┘
Markdown	[Skip to main content](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax#__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/argmax) - [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/argmax) - [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/argmax) - [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/argmax) - [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\.8k](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=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725) [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/argmax) - [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax) - [日本語](https://clickhouse.com/docs/jp/sql-reference/aggregate-functions/reference/argmax) - [中文](https://clickhouse.com/docs/zh/sql-reference/aggregate-functions/reference/argmax) - [Русский](https://clickhouse.com/docs/ru/sql-reference/aggregate-functions/reference/argmax) - [한국어](https://clickhouse.com/docs/ko/sql-reference/aggregate-functions/reference/argmax) [Skip to main content](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax#__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/argmax) - [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/argmax) - [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/argmax) - [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/argmax) - [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\.8k](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=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725) [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/argmax) - [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax) - [日本語](https://clickhouse.com/docs/jp/sql-reference/aggregate-functions/reference/argmax) - [中文](https://clickhouse.com/docs/zh/sql-reference/aggregate-functions/reference/argmax) - [Русский](https://clickhouse.com/docs/ru/sql-reference/aggregate-functions/reference/argmax) - [한국어](https://clickhouse.com/docs/ko/sql-reference/aggregate-functions/reference/argmax) [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/argmax) - [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](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference) - argMax [Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/sql-reference/aggregate-functions/reference/argMax.md) # argMax ## argMax[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax#argMax "Direct link to argMax") Introduced in: v1.1.0 Calculates the `arg` value for a maximum `val` value. If there are multiple rows with equal `val` being the maximum, which of the associated `arg` is returned is not deterministic. Both parts the `arg` and the `max` behave as [aggregate functions](https://clickhouse.com/docs/sql-reference/aggregate-functions), they both [skip `Null`](https://clickhouse.com/docs/sql-reference/aggregate-functions#null-processing) during processing and return not `Null` values if not `Null` values are available. See also - [Tuple](https://clickhouse.com/docs/sql-reference/data-types/tuple) Syntax ``` argMax(arg, val) ``` Arguments - `arg` — Argument for which to find the maximum value. [`const String`](https://clickhouse.com/docs/sql-reference/data-types/string) - `val` — The maximum value. [`(U)Int8/16/32/64`](https://clickhouse.com/docs/sql-reference/data-types/int-uint) or [`Float`](https://clickhouse.com/docs/sql-reference/data-types/float) or [`Date`](https://clickhouse.com/docs/sql-reference/data-types/date) or [`DateTime`](https://clickhouse.com/docs/sql-reference/data-types/datetime) or [`Tuple`](https://clickhouse.com/docs/sql-reference/data-types/tuple) Returned value* Returns the `arg` value that corresponds to maximum `val` value. Type matches `arg` type. Examples Basic usage Query ``` SELECT argMax(user, salary) FROM salary; ``` Response ``` ┌─argMax(user, salary)─┐ │ director │ └──────────────────────┘ ``` Extended example with NULL handling Query ``` CREATE TABLE test ( a Nullable(String), b Nullable(Int64) ) ENGINE = Memory AS SELECT * FROM VALUES(('a', 1), ('b', 2), ('c', 2), (NULL, 3), (NULL, NULL), ('d', NULL)); SELECT argMax(a, b), max(b) FROM test; ``` Response ``` ┌─argMax(a, b)─┬─max(b)─┐ │ b │ 3 │ └──────────────┴────────┘ ``` Using Tuple in arguments Query ``` SELECT argMax(a, (b,a)) FROM test; ``` Response ``` ┌─argMax(a, tuple(b, a))─┐ │ c │ └────────────────────────┘ ``` [Previous argAndMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argandmin) [Next argMin](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmin) - [argMax](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax#argMax) 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=61d0999d-f035-4596-bf24-1a4ad031b503&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Fargmax&utm_ga=GA1.1.1540741568.1775696725) © 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▼ - Regular functions▼ - Aggregate functions▼ - Aggregate Functions▼ - [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▼ - Table functions▼ - Window functions▼ - Formats▼ - [Data Lakes](https://clickhouse.com/docs/sql-reference/datalakes)
Readable Markdown	## argMax[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/argmax#argMax "Direct link to argMax") Introduced in: v1.1.0 Calculates the `arg` value for a maximum `val` value. If there are multiple rows with equal `val` being the maximum, which of the associated `arg` is returned is not deterministic. Both parts the `arg` and the `max` behave as [aggregate functions](https://clickhouse.com/docs/sql-reference/aggregate-functions), they both [skip `Null`](https://clickhouse.com/docs/sql-reference/aggregate-functions#null-processing) during processing and return not `Null` values if not `Null` values are available. See also - [Tuple](https://clickhouse.com/docs/sql-reference/data-types/tuple) Syntax ``` argMax(arg, val) ``` Arguments - `arg` — Argument for which to find the maximum value. [`const String`](https://clickhouse.com/docs/sql-reference/data-types/string) - `val` — The maximum value. [`(U)Int8/16/32/64`](https://clickhouse.com/docs/sql-reference/data-types/int-uint) or [`Float`](https://clickhouse.com/docs/sql-reference/data-types/float) or [`Date`](https://clickhouse.com/docs/sql-reference/data-types/date) or [`DateTime`](https://clickhouse.com/docs/sql-reference/data-types/datetime) or [`Tuple`](https://clickhouse.com/docs/sql-reference/data-types/tuple) Returned value* Returns the `arg` value that corresponds to maximum `val` value. Type matches `arg` type. Examples Basic usage Query ``` SELECT argMax(user, salary) FROM salary; ``` Response ``` ┌─argMax(user, salary)─┐ │ director │ └──────────────────────┘ ``` Extended example with NULL handling Query ``` CREATE TABLE test ( a Nullable(String), b Nullable(Int64) ) ENGINE = Memory AS SELECT * FROM VALUES(('a', 1), ('b', 2), ('c', 2), (NULL, 3), (NULL, NULL), ('d', NULL)); SELECT argMax(a, b), max(b) FROM test; ``` Response ``` ┌─argMax(a, b)─┬─max(b)─┐ │ b │ 3 │ └──────────────┴────────┘ ``` Using Tuple in arguments Query ``` SELECT argMax(a, (b,a)) FROM test; ``` Response ``` ┌─argMax(a, tuple(b, a))─┐ │ c │ └────────────────────────┘ ```
Shard	89 (laksa)
Root Hash	12633450985039531489
Unparsed URL	com,clickhouse!/docs/sql-reference/aggregate-functions/reference/argmax s443