🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 89 (from laksa120)

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

Response:

{"found_url":"https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value","crawl_time":1775254272,"first_indexed_time":1740537099,"http_code":200,"src_unparsed":"com,clickhouse!\/docs\/sql-reference\/aggregate-functions\/reference\/first_value s443","src_root_hash":"12633450985039531489","history_drop_reason":null,"meta_title":"first_value | ClickHouse Docs","meta_descriptions":["It is an alias for any but it was introduced for compatibility with Window Functions, where sometimes it is necessary to process `NULL` values (by default all ClickHouse aggregate functions ignore NULL values)."],"attrs_boilerpipe_text":"It is an alias for\nany\nbut it was introduced for compatibility with\nWindow Functions\n, where sometimes it's necessary to process\nNULL\nvalues (by default all ClickHouse aggregate functions ignore NULL values).\nIt supports declaring a modifier to respect nulls (\nRESPECT NULLS\n), both under\nWindow Functions\nand in normal aggregations.\nAs with\nany\n, without Window Functions the result will be random if the source stream is not ordered and the return type\nmatches the input type (Null is only returned if the input is Nullable or -OrNull combinator is added).\nexamples\n\nCREATE\nTABLE\ntest_data\n(\na Int64\n,\nb Nullable\n(\nInt64\n)\n)\nENGINE\n=\nMemory\n;\nINSERT\nINTO\ntest_data\n(\na\n,\nb\n)\nVALUES\n(\n1\n,\nnull\n)\n,\n(\n2\n,\n3\n)\n,\n(\n4\n,\n5\n)\n,\n(\n6\n,\nnull\n)\n;\nExample 1\n\nBy default, the NULL value is ignored.\nSELECT\nfirst_value\n(\nb\n)\nFROM\ntest_data\n;\n┌─any(b)─┐\n│      3 │\n└────────┘\nExample 2\n\nThe NULL value is ignored.\nSELECT\nfirst_value\n(\nb\n)\nignore\nnulls\nFROM\ntest_data\n┌─any(b) IGNORE NULLS ─┐\n│                    3 │\n└──────────────────────┘\nExample 3\n\nThe NULL value is accepted.\nSELECT\nfirst_value\n(\nb\n)\nrespect nulls\nFROM\ntest_data\n┌─any(b) RESPECT NULLS ─┐\n│                  ᴺᵁᴸᴸ │\n└───────────────────────┘\nExample 4\n\nStabilized result using the sub-query with\nORDER BY\n.\nSELECT\nfirst_value_respect_nulls\n(\nb\n)\n,\nfirst_value\n(\nb\n)\nFROM\n(\nSELECT\n*\nFROM\ntest_data\nORDER\nBY\na\nASC\n)\n┌─any_respect_nulls(b)─┬─any(b)─┐\n│                 ᴺᵁᴸᴸ │      3 │\n└──────────────────────┴────────┘","attrs_markdown":"[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#__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\/first_value)\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\/first_value)\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\/first_value)\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\/first_value)\n    - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n    - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n    - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n    - [Rockset](https:\/\/clickhouse.com\/comparison\/rockset)\n    - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n  - [Video](https:\/\/clickhouse.com\/videos)\n  - [Demo](https:\/\/clickhouse.com\/demos)\n- [Pricing](https:\/\/clickhouse.com\/pricing)\n- [Contact](https:\/\/clickhouse.com\/company\/contact?loc=nav)\n\n[46\\.7k](https:\/\/github.com\/ClickHouse\/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav)\n\n[Search`Ctrl``K`](https:\/\/clickhouse.com\/docs\/search)\n\n[Sign in](https:\/\/console.clickhouse.cloud\/signIn?loc=docs-nav-signIn-cta&glxid=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274)\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\/first_value)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/aggregate-functions\/reference\/first_value)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/aggregate-functions\/reference\/first_value)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/aggregate-functions\/reference\/first_value)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/aggregate-functions\/reference\/first_value)\n\n[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#__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\/first_value)\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\/first_value)\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\/first_value)\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\/first_value)\n    - [BigQuery](https:\/\/clickhouse.com\/comparison\/bigquery)\n    - [PostgreSQL](https:\/\/clickhouse.com\/comparison\/postgresql)\n    - [Redshift](https:\/\/clickhouse.com\/comparison\/redshift)\n    - [Rockset](https:\/\/clickhouse.com\/comparison\/rockset)\n    - [Snowflake](https:\/\/clickhouse.com\/comparison\/snowflake)\n  - [Video](https:\/\/clickhouse.com\/videos)\n  - [Demo](https:\/\/clickhouse.com\/demos)\n- [Pricing](https:\/\/clickhouse.com\/pricing)\n- [Contact](https:\/\/clickhouse.com\/company\/contact?loc=nav)\n\n[46\\.7k](https:\/\/github.com\/ClickHouse\/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav)\n\n[Search`Ctrl``K`](https:\/\/clickhouse.com\/docs\/search)\n\n[Sign in](https:\/\/console.clickhouse.cloud\/signIn?loc=docs-nav-signIn-cta&glxid=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274)\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\/first_value)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/aggregate-functions\/reference\/first_value)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/aggregate-functions\/reference\/first_value)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/aggregate-functions\/reference\/first_value)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/aggregate-functions\/reference\/first_value)\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\/first_value)\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- first\\_value\n\n[Edit this page](https:\/\/github.com\/ClickHouse\/ClickHouse\/tree\/master\/docs\/en\/sql-reference\/aggregate-functions\/reference\/first_value.md)\n\n# first\\_value\nIt is an alias for [`any`](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/any) but it was introduced for compatibility with [Window Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/window-functions), where sometimes it's necessary to process `NULL` values (by default all ClickHouse aggregate functions ignore NULL values).\n\nIt supports declaring a modifier to respect nulls (`RESPECT NULLS`), both under [Window Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/window-functions) and in normal aggregations.\n\nAs with `any`, without Window Functions the result will be random if the source stream is not ordered and the return type matches the input type (Null is only returned if the input is Nullable or -OrNull combinator is added).\n\n## examples[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#examples \"Direct link to examples\")\n```\nCREATE TABLE test_data\n(\n    a Int64,\n    b Nullable(Int64)\n)\nENGINE = Memory;\n\nINSERT INTO test_data (a, b) VALUES (1,null), (2,3), (4, 5), (6,null);\n```\n### Example 1[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example1 \"Direct link to Example 1\")\nBy default, the NULL value is ignored.\n```\nSELECT first_value(b) FROM test_data;\n```\n```\n┌─any(b)─┐\n│      3 │\n└────────┘\n```\n### Example 2[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example2 \"Direct link to Example 2\")\nThe NULL value is ignored.\n```\nSELECT first_value(b) ignore nulls FROM test_data\n```\n```\n┌─any(b) IGNORE NULLS ─┐\n│                    3 │\n└──────────────────────┘\n```\n### Example 3[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example3 \"Direct link to Example 3\")\nThe NULL value is accepted.\n```\nSELECT first_value(b) respect nulls FROM test_data\n```\n```\n┌─any(b) RESPECT NULLS ─┐\n│                  ᴺᵁᴸᴸ │\n└───────────────────────┘\n```\n### Example 4[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example4 \"Direct link to Example 4\")\nStabilized result using the sub-query with `ORDER BY`.\n```\nSELECT\n    first_value_respect_nulls(b),\n    first_value(b)\nFROM\n(\n    SELECT *\n    FROM test_data\n    ORDER BY a ASC\n)\n```\n```\n┌─any_respect_nulls(b)─┬─any(b)─┐\n│                 ᴺᵁᴸᴸ │      3 │\n└──────────────────────┴────────┘\n```\n\n[Previous exponentialTimeDecayedSum](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/exponentialTimeDecayedSum)\n\n[Next flameGraph](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/flame_graph)\n\n- [examples](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#examples)\n  - [Example 1](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example1)\n  - [Example 2](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example2)\n  - [Example 3](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example3)\n  - [Example 4](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example4)\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=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274)\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":"It is an alias for [`any`](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/any) but it was introduced for compatibility with [Window Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/window-functions), where sometimes it's necessary to process `NULL` values (by default all ClickHouse aggregate functions ignore NULL values).\n\nIt supports declaring a modifier to respect nulls (`RESPECT NULLS`), both under [Window Functions](https:\/\/clickhouse.com\/docs\/sql-reference\/window-functions) and in normal aggregations.\n\nAs with `any`, without Window Functions the result will be random if the source stream is not ordered and the return type matches the input type (Null is only returned if the input is Nullable or -OrNull combinator is added).\n\n## examples[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#examples \"Direct link to examples\")\n```\nCREATE TABLE test_data\n(\n    a Int64,\n    b Nullable(Int64)\n)\nENGINE = Memory;\n\nINSERT INTO test_data (a, b) VALUES (1,null), (2,3), (4, 5), (6,null);\n```\n### Example 1[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example1 \"Direct link to Example 1\")\nBy default, the NULL value is ignored.\n```\nSELECT first_value(b) FROM test_data;\n```\n```\n┌─any(b)─┐\n│      3 │\n└────────┘\n```\n### Example 2[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example2 \"Direct link to Example 2\")\nThe NULL value is ignored.\n```\nSELECT first_value(b) ignore nulls FROM test_data\n```\n```\n┌─any(b) IGNORE NULLS ─┐\n│                    3 │\n└──────────────────────┘\n```\n### Example 3[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example3 \"Direct link to Example 3\")\nThe NULL value is accepted.\n```\nSELECT first_value(b) respect nulls FROM test_data\n```\n```\n┌─any(b) RESPECT NULLS ─┐\n│                  ᴺᵁᴸᴸ │\n└───────────────────────┘\n```\n### Example 4[](https:\/\/clickhouse.com\/docs\/sql-reference\/aggregate-functions\/reference\/first_value#example4 \"Direct link to Example 4\")\nStabilized result using the sub-query with `ORDER BY`.\n```\nSELECT\n    first_value_respect_nulls(b),\n    first_value(b)\nFROM\n(\n    SELECT *\n    FROM test_data\n    ORDER BY a ASC\n)\n```\n```\n┌─any_respect_nulls(b)─┬─any(b)─┐\n│                 ᴺᵁᴸᴸ │      3 │\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

4 days ago

🤖

ROBOTS ALLOWED

Page Info Filters

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

Page Details

Property	Value
URL	https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value
Last Crawled	2026-04-03 22:11:12 (4 days ago)
First Indexed	2025-02-26 02:31:39 (1 year ago)
HTTP Status Code	200
Meta Title	first_value \| ClickHouse Docs
Meta Description	It is an alias for any but it was introduced for compatibility with Window Functions, where sometimes it is necessary to process `NULL` values (by default all ClickHouse aggregate functions ignore NULL values).
Meta Canonical	null
Boilerpipe Text	It is an alias for any but it was introduced for compatibility with Window Functions , where sometimes it's necessary to process NULL values (by default all ClickHouse aggregate functions ignore NULL values). It supports declaring a modifier to respect nulls ( RESPECT NULLS ), both under Window Functions and in normal aggregations. As with any , without Window Functions the result will be random if the source stream is not ordered and the return type matches the input type (Null is only returned if the input is Nullable or -OrNull combinator is added). examples CREATE TABLE test_data ( a Int64 , b Nullable ( Int64 ) ) ENGINE = Memory ; INSERT INTO test_data ( a , b ) VALUES ( 1 , null ) , ( 2 , 3 ) , ( 4 , 5 ) , ( 6 , null ) ; Example 1 By default, the NULL value is ignored. SELECT first_value ( b ) FROM test_data ; ┌─any(b)─┐ │ 3 │ └────────┘ Example 2 The NULL value is ignored. SELECT first_value ( b ) ignore nulls FROM test_data ┌─any(b) IGNORE NULLS ─┐ │ 3 │ └──────────────────────┘ Example 3 The NULL value is accepted. SELECT first_value ( b ) respect nulls FROM test_data ┌─any(b) RESPECT NULLS ─┐ │ ᴺᵁᴸᴸ │ └───────────────────────┘ Example 4 Stabilized result using the sub-query with ORDER BY . SELECT first_value_respect_nulls ( b ) , first_value ( b ) FROM ( SELECT * FROM test_data ORDER BY a ASC ) ┌─any_respect_nulls(b)─┬─any(b)─┐ │ ᴺᵁᴸᴸ │ 3 │ └──────────────────────┴────────┘
Markdown	[Skip to main content](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#__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/first_value) - [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/first_value) - [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/first_value) - [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/first_value) - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Rockset](https://clickhouse.com/comparison/rockset) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Video](https://clickhouse.com/videos) - [Demo](https://clickhouse.com/demos) - [Pricing](https://clickhouse.com/pricing) - [Contact](https://clickhouse.com/company/contact?loc=nav) [46\.7k](https://github.com/ClickHouse/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav) [Search`Ctrl``K`](https://clickhouse.com/docs/search) [Sign in](https://console.clickhouse.cloud/signIn?loc=docs-nav-signIn-cta&glxid=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274) [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/first_value) - [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value) - [日本語](https://clickhouse.com/docs/jp/sql-reference/aggregate-functions/reference/first_value) - [中文](https://clickhouse.com/docs/zh/sql-reference/aggregate-functions/reference/first_value) - [Русский](https://clickhouse.com/docs/ru/sql-reference/aggregate-functions/reference/first_value) - [한국어](https://clickhouse.com/docs/ko/sql-reference/aggregate-functions/reference/first_value) [Skip to main content](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#__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/first_value) - [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/first_value) - [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/first_value) - [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/first_value) - [BigQuery](https://clickhouse.com/comparison/bigquery) - [PostgreSQL](https://clickhouse.com/comparison/postgresql) - [Redshift](https://clickhouse.com/comparison/redshift) - [Rockset](https://clickhouse.com/comparison/rockset) - [Snowflake](https://clickhouse.com/comparison/snowflake) - [Video](https://clickhouse.com/videos) - [Demo](https://clickhouse.com/demos) - [Pricing](https://clickhouse.com/pricing) - [Contact](https://clickhouse.com/company/contact?loc=nav) [46\.7k](https://github.com/ClickHouse/ClickHouse?utm_source=clickhouse&utm_medium=website&utm_campaign=website-nav) [Search`Ctrl``K`](https://clickhouse.com/docs/search) [Sign in](https://console.clickhouse.cloud/signIn?loc=docs-nav-signIn-cta&glxid=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274) [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/first_value) - [English](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value) - [日本語](https://clickhouse.com/docs/jp/sql-reference/aggregate-functions/reference/first_value) - [中文](https://clickhouse.com/docs/zh/sql-reference/aggregate-functions/reference/first_value) - [Русский](https://clickhouse.com/docs/ru/sql-reference/aggregate-functions/reference/first_value) - [한국어](https://clickhouse.com/docs/ko/sql-reference/aggregate-functions/reference/first_value) [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/first_value) - [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) - first\_value [Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/sql-reference/aggregate-functions/reference/first_value.md) # first\_value It is an alias for [`any`](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/any) but it was introduced for compatibility with [Window Functions](https://clickhouse.com/docs/sql-reference/window-functions), where sometimes it's necessary to process `NULL` values (by default all ClickHouse aggregate functions ignore NULL values). It supports declaring a modifier to respect nulls (`RESPECT NULLS`), both under [Window Functions](https://clickhouse.com/docs/sql-reference/window-functions) and in normal aggregations. As with `any`, without Window Functions the result will be random if the source stream is not ordered and the return type matches the input type (Null is only returned if the input is Nullable or -OrNull combinator is added). ## examples[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#examples "Direct link to examples") ``` CREATE TABLE test_data ( a Int64, b Nullable(Int64) ) ENGINE = Memory; INSERT INTO test_data (a, b) VALUES (1,null), (2,3), (4, 5), (6,null); ``` ### Example 1[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example1 "Direct link to Example 1") By default, the NULL value is ignored. ``` SELECT first_value(b) FROM test_data; ``` ``` ┌─any(b)─┐ │ 3 │ └────────┘ ``` ### Example 2[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example2 "Direct link to Example 2") The NULL value is ignored. ``` SELECT first_value(b) ignore nulls FROM test_data ``` ``` ┌─any(b) IGNORE NULLS ─┐ │ 3 │ └──────────────────────┘ ``` ### Example 3[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example3 "Direct link to Example 3") The NULL value is accepted. ``` SELECT first_value(b) respect nulls FROM test_data ``` ``` ┌─any(b) RESPECT NULLS ─┐ │ ᴺᵁᴸᴸ │ └───────────────────────┘ ``` ### Example 4[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example4 "Direct link to Example 4") Stabilized result using the sub-query with `ORDER BY`. ``` SELECT first_value_respect_nulls(b), first_value(b) FROM ( SELECT * FROM test_data ORDER BY a ASC ) ``` ``` ┌─any_respect_nulls(b)─┬─any(b)─┐ │ ᴺᵁᴸᴸ │ 3 │ └──────────────────────┴────────┘ ``` [Previous exponentialTimeDecayedSum](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/exponentialTimeDecayedSum) [Next flameGraph](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/flame_graph) - [examples](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#examples) - [Example 1](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example1) - [Example 2](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example2) - [Example 3](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example3) - [Example 4](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example4) 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=ecd72ccd-7165-4c64-96d9-7394301d8346&pagePath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&origPath=%2Fdocs%2Fsql-reference%2Faggregate-functions%2Freference%2Ffirst_value&utm_ga=GA1.1.986230155.1775254274) © 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	It is an alias for [`any`](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/any) but it was introduced for compatibility with [Window Functions](https://clickhouse.com/docs/sql-reference/window-functions), where sometimes it's necessary to process `NULL` values (by default all ClickHouse aggregate functions ignore NULL values). It supports declaring a modifier to respect nulls (`RESPECT NULLS`), both under [Window Functions](https://clickhouse.com/docs/sql-reference/window-functions) and in normal aggregations. As with `any`, without Window Functions the result will be random if the source stream is not ordered and the return type matches the input type (Null is only returned if the input is Nullable or -OrNull combinator is added). ## examples[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#examples "Direct link to examples") ``` CREATE TABLE test_data ( a Int64, b Nullable(Int64) ) ENGINE = Memory; INSERT INTO test_data (a, b) VALUES (1,null), (2,3), (4, 5), (6,null); ``` ### Example 1[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example1 "Direct link to Example 1") By default, the NULL value is ignored. ``` SELECT first_value(b) FROM test_data; ``` ``` ┌─any(b)─┐ │ 3 │ └────────┘ ``` ### Example 2[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example2 "Direct link to Example 2") The NULL value is ignored. ``` SELECT first_value(b) ignore nulls FROM test_data ``` ``` ┌─any(b) IGNORE NULLS ─┐ │ 3 │ └──────────────────────┘ ``` ### Example 3[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example3 "Direct link to Example 3") The NULL value is accepted. ``` SELECT first_value(b) respect nulls FROM test_data ``` ``` ┌─any(b) RESPECT NULLS ─┐ │ ᴺᵁᴸᴸ │ └───────────────────────┘ ``` ### Example 4[](https://clickhouse.com/docs/sql-reference/aggregate-functions/reference/first_value#example4 "Direct link to Example 4") Stabilized result using the sub-query with `ORDER BY`. ``` SELECT first_value_respect_nulls(b), first_value(b) FROM ( SELECT * FROM test_data ORDER BY a ASC ) ``` ``` ┌─any_respect_nulls(b)─┬─any(b)─┐ │ ᴺᵁᴸᴸ │ 3 │ └──────────────────────┴────────┘ ```
Shard	89 (laksa)
Root Hash	12633450985039531489
Unparsed URL	com,clickhouse!/docs/sql-reference/aggregate-functions/reference/first_value s443