🕷️ Crawler Inspector

URL Lookup

Direct Parameter Lookup

Raw Queries and Responses

1. Shard Calculation

Query:

Response:

Calculated Shard: 89 (from laksa140)

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

Response:

{"found_url":"https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having","crawl_time":1774535741,"first_indexed_time":1740107262,"http_code":200,"src_unparsed":"com,clickhouse!\/docs\/sql-reference\/statements\/select\/having s443","src_root_hash":"12633450985039531489","history_drop_reason":null,"meta_title":"HAVING Clause | ClickHouse Docs","meta_descriptions":["Documentation for HAVING Clause"],"attrs_boilerpipe_text":"Allows filtering the aggregation results produced by\nGROUP BY\n. It is similar to the\nWHERE\nclause, but the difference is that\nWHERE\nis performed before aggregation, while\nHAVING\nis performed after it.\nIt is possible to reference aggregation results from\nSELECT\nclause in\nHAVING\nclause by their alias. Alternatively,\nHAVING\nclause can filter on results of additional aggregates that are not returned in query results.\nExample\n\nIf you have a\nsales\ntable as follows:\nCREATE\nTABLE\nsales\n(\nregion String\n,\nsalesperson String\n,\namount Float64\n)\nORDER\nBY\n(\nregion\n,\nsalesperson\n)\n;\nYou can query it like so:\nSELECT\nregion\n,\nsalesperson\n,\nsum\n(\namount\n)\nAS\ntotal_sales\nFROM\nsales\nGROUP\nBY\nregion\n,\nsalesperson\nHAVING\ntotal_sales\n>\n10000\nORDER\nBY\ntotal_sales\nDESC\n;\nThis will list sales people with greater than 10,000 in total sales in their region.\nLimitations\n\nHAVING\ncan't be used if aggregation is not performed. Use\nWHERE\ninstead.","attrs_markdown":"[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having#__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\/statements\/select\/having)\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\/statements\/select\/having)\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\/statements\/select\/having)\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\/statements\/select\/having)\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\\.5k](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=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743)\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\/statements\/select\/having)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/statements\/select\/having)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/statements\/select\/having)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/statements\/select\/having)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/statements\/select\/having)\n\n[Skip to main content](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having#__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\/statements\/select\/having)\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\/statements\/select\/having)\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\/statements\/select\/having)\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\/statements\/select\/having)\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\\.5k](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=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743)\n\n[Get started](https:\/\/console.clickhouse.cloud\/signUp?loc=docs-nav-signUp-cta&glxid=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743)\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\/statements\/select\/having)\n\n- [English](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having)\n- [日本語](https:\/\/clickhouse.com\/docs\/jp\/sql-reference\/statements\/select\/having)\n- [中文](https:\/\/clickhouse.com\/docs\/zh\/sql-reference\/statements\/select\/having)\n- [Русский](https:\/\/clickhouse.com\/docs\/ru\/sql-reference\/statements\/select\/having)\n- [한국어](https:\/\/clickhouse.com\/docs\/ko\/sql-reference\/statements\/select\/having)\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    - [SELECT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select)\n      - [ALL](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/all)\n      - [APPLY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/apply-modifier)\n      - [ARRAY JOIN](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/array-join)\n      - [DISTINCT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/distinct)\n      - [EXCEPT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/except)\n      - [EXCEPT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/except-modifier)\n      - [FORMAT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/format)\n      - [FROM](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/from)\n      - [GROUP BY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/group-by)\n      - [HAVING](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having)\n      - [INTERSECT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/intersect)\n      - [INTO OUTFILE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/into-outfile)\n      - [JOIN](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/join)\n      - [LIMIT BY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/limit-by)\n      - [LIMIT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/limit)\n      - [OFFSET](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/offset)\n      - [ORDER BY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/order-by)\n      - [PREWHERE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/prewhere)\n      - [QUALIFY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/qualify)\n      - [REPLACE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/replace-modifier)\n      - [SAMPLE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/sample)\n      - [UNION](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/union)\n      - [WHERE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/where)\n      - [WITH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/with)\n    - [INSERT INTO](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/insert-into)\n    - [CREATE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/create)\n    - [ALTER](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/alter)\n    - [DELETE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/delete)\n    - [SYSTEM](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/system)\n    - [SHOW](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/show)\n    - [GRANT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/grant)\n    - [EXPLAIN](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/explain)\n    - [REVOKE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/revoke)\n    - [UPDATE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/update)\n    - [ATTACH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/attach)\n    - [CHECK TABLE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/check-table)\n    - [DESCRIBE TABLE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/describe-table)\n    - [DETACH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/detach)\n    - [DROP](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/drop)\n    - [EXISTS](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/exists)\n    - [KILL](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/kill)\n    - [OPTIMIZE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/optimize)\n    - [RENAME](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/rename)\n    - [EXCHANGE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/exchange)\n    - [SET](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/set)\n    - [SET ROLE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/set-role)\n    - [TRUNCATE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/truncate)\n    - [EXECUTE AS](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/execute_as)\n    - [PARALLEL WITH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/parallel_with)\n    - [USE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/use)\n    - [WATCH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/watch)\n    - [MOVE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/move)\n    - [CHECK GRANT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/check-grant)\n    - [UNDROP](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/undrop)\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  - [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- [Introduction](https:\/\/clickhouse.com\/docs\/sql-reference)\n- [Statements](https:\/\/clickhouse.com\/docs\/sql-reference\/statements)\n- [SELECT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select)\n- HAVING\n\n[Edit this page](https:\/\/github.com\/ClickHouse\/ClickHouse\/tree\/master\/docs\/en\/sql-reference\/statements\/select\/having.md)\n\n# HAVING Clause\nAllows filtering the aggregation results produced by [GROUP BY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/group-by). It is similar to the [WHERE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/where) clause, but the difference is that `WHERE` is performed before aggregation, while `HAVING` is performed after it.\n\nIt is possible to reference aggregation results from `SELECT` clause in `HAVING` clause by their alias. Alternatively, `HAVING` clause can filter on results of additional aggregates that are not returned in query results.\n\n## Example[](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having#example \"Direct link to Example\")\nIf you have a `sales` table as follows:\n```\nCREATE TABLE sales\n(\n    region String,\n    salesperson String,\n    amount Float64\n)\nORDER BY (region, salesperson);\n```\nYou can query it like so:\n```\nSELECT\n    region,\n    salesperson,\n    sum(amount) AS total_sales\nFROM sales\nGROUP BY\n    region,\n    salesperson\nHAVING total_sales > 10000\nORDER BY total_sales DESC;\n```\nThis will list sales people with greater than 10,000 in total sales in their region.\n\n## Limitations[](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having#limitations \"Direct link to Limitations\")\n`HAVING` can't be used if aggregation is not performed. Use `WHERE` instead.\n\n[Previous GROUP BY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/group-by)\n\n[Next INTERSECT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/intersect)\n\n- [Example](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having#example)\n- [Limitations](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having#limitations)\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=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743)\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    - SELECT▼\n      - [ALL](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/all)\n      - [APPLY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/apply-modifier)\n      - [ARRAY JOIN](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/array-join)\n      - [DISTINCT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/distinct)\n      - [EXCEPT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/except)\n      - [EXCEPT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/except-modifier)\n      - [FORMAT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/format)\n      - [FROM](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/from)\n      - [GROUP BY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/group-by)\n      - [HAVING](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having)\n      - [INTERSECT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/intersect)\n      - [INTO OUTFILE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/into-outfile)\n      - [JOIN](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/join)\n      - [LIMIT BY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/limit-by)\n      - [LIMIT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/limit)\n      - [OFFSET](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/offset)\n      - [ORDER BY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/order-by)\n      - [PREWHERE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/prewhere)\n      - [QUALIFY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/qualify)\n      - [REPLACE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/replace-modifier)\n      - [SAMPLE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/sample)\n      - [UNION](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/union)\n      - [WHERE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/where)\n      - [WITH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/with)\n    - [INSERT INTO](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/insert-into)\n    - CREATE▼\n    - ALTER▼\n    - [DELETE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/delete)\n    - [SYSTEM](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/system)\n    - [SHOW](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/show)\n    - [GRANT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/grant)\n    - [EXPLAIN](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/explain)\n    - [REVOKE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/revoke)\n    - [UPDATE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/update)\n    - [ATTACH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/attach)\n    - [CHECK TABLE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/check-table)\n    - [DESCRIBE TABLE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/describe-table)\n    - [DETACH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/detach)\n    - [DROP](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/drop)\n    - [EXISTS](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/exists)\n    - [KILL](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/kill)\n    - [OPTIMIZE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/optimize)\n    - [RENAME](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/rename)\n    - [EXCHANGE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/exchange)\n    - [SET](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/set)\n    - [SET ROLE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/set-role)\n    - [TRUNCATE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/truncate)\n    - [EXECUTE AS](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/execute_as)\n    - [PARALLEL WITH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/parallel_with)\n    - [USE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/use)\n    - [WATCH](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/watch)\n    - [MOVE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/move)\n    - [CHECK GRANT](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/check-grant)\n    - [UNDROP](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/undrop)\n  - Operators▼\n- Engines▼\n- Functions▼\n- Formats▼\n- [Data Lakes](https:\/\/clickhouse.com\/docs\/sql-reference\/datalakes)","attrs_readable_markdown":"Allows filtering the aggregation results produced by [GROUP BY](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/group-by). It is similar to the [WHERE](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/where) clause, but the difference is that `WHERE` is performed before aggregation, while `HAVING` is performed after it.\n\nIt is possible to reference aggregation results from `SELECT` clause in `HAVING` clause by their alias. Alternatively, `HAVING` clause can filter on results of additional aggregates that are not returned in query results.\n\n## Example[](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having#example \"Direct link to Example\")\nIf you have a `sales` table as follows:\n```\nCREATE TABLE sales\n(\n    region String,\n    salesperson String,\n    amount Float64\n)\nORDER BY (region, salesperson);\n```\nYou can query it like so:\n```\nSELECT\n    region,\n    salesperson,\n    sum(amount) AS total_sales\nFROM sales\nGROUP BY\n    region,\n    salesperson\nHAVING total_sales > 10000\nORDER BY total_sales DESC;\n```\nThis will list sales people with greater than 10,000 in total sales in their region.\n\n## Limitations[](https:\/\/clickhouse.com\/docs\/sql-reference\/statements\/select\/having#limitations \"Direct link to Limitations\")\n`HAVING` can't be used if aggregation is not performed. Use `WHERE` instead.","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

14 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.5 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/statements/select/having
Last Crawled	2026-03-26 14:35:41 (14 days ago)
First Indexed	2025-02-21 03:07:42 (1 year ago)
HTTP Status Code	200
Meta Title	HAVING Clause \| ClickHouse Docs
Meta Description	Documentation for HAVING Clause
Meta Canonical	null
Boilerpipe Text	Allows filtering the aggregation results produced by GROUP BY . It is similar to the WHERE clause, but the difference is that WHERE is performed before aggregation, while HAVING is performed after it. It is possible to reference aggregation results from SELECT clause in HAVING clause by their alias. Alternatively, HAVING clause can filter on results of additional aggregates that are not returned in query results. Example If you have a sales table as follows: CREATE TABLE sales ( region String , salesperson String , amount Float64 ) ORDER BY ( region , salesperson ) ; You can query it like so: SELECT region , salesperson , sum ( amount ) AS total_sales FROM sales GROUP BY region , salesperson HAVING total_sales > 10000 ORDER BY total_sales DESC ; This will list sales people with greater than 10,000 in total sales in their region. Limitations HAVING can't be used if aggregation is not performed. Use WHERE instead.
Markdown	[Skip to main content](https://clickhouse.com/docs/sql-reference/statements/select/having#__docusaurus_skipToContent_fallback) [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) - [Products](https://clickhouse.com/docs/sql-reference/statements/select/having) - [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/statements/select/having) - [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/statements/select/having) - [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/statements/select/having) - [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\.5k](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=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743) [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/statements/select/having) - [English](https://clickhouse.com/docs/sql-reference/statements/select/having) - [日本語](https://clickhouse.com/docs/jp/sql-reference/statements/select/having) - [中文](https://clickhouse.com/docs/zh/sql-reference/statements/select/having) - [Русский](https://clickhouse.com/docs/ru/sql-reference/statements/select/having) - [한국어](https://clickhouse.com/docs/ko/sql-reference/statements/select/having) [Skip to main content](https://clickhouse.com/docs/sql-reference/statements/select/having#__docusaurus_skipToContent_fallback) [![ClickHouse](https://clickhouse.com/docs/img/ch_logo_docs.svg)](https://clickhouse.com/) - [Products](https://clickhouse.com/docs/sql-reference/statements/select/having) - [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/statements/select/having) - [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/statements/select/having) - [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/statements/select/having) - [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\.5k](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=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743) [Get started](https://console.clickhouse.cloud/signUp?loc=docs-nav-signUp-cta&glxid=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743) [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/statements/select/having) - [English](https://clickhouse.com/docs/sql-reference/statements/select/having) - [日本語](https://clickhouse.com/docs/jp/sql-reference/statements/select/having) - [中文](https://clickhouse.com/docs/zh/sql-reference/statements/select/having) - [Русский](https://clickhouse.com/docs/ru/sql-reference/statements/select/having) - [한국어](https://clickhouse.com/docs/ko/sql-reference/statements/select/having) [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) - [SELECT](https://clickhouse.com/docs/sql-reference/statements/select) - [ALL](https://clickhouse.com/docs/sql-reference/statements/select/all) - [APPLY](https://clickhouse.com/docs/sql-reference/statements/select/apply-modifier) - [ARRAY JOIN](https://clickhouse.com/docs/sql-reference/statements/select/array-join) - [DISTINCT](https://clickhouse.com/docs/sql-reference/statements/select/distinct) - [EXCEPT](https://clickhouse.com/docs/sql-reference/statements/select/except) - [EXCEPT](https://clickhouse.com/docs/sql-reference/statements/select/except-modifier) - [FORMAT](https://clickhouse.com/docs/sql-reference/statements/select/format) - [FROM](https://clickhouse.com/docs/sql-reference/statements/select/from) - [GROUP BY](https://clickhouse.com/docs/sql-reference/statements/select/group-by) - [HAVING](https://clickhouse.com/docs/sql-reference/statements/select/having) - [INTERSECT](https://clickhouse.com/docs/sql-reference/statements/select/intersect) - [INTO OUTFILE](https://clickhouse.com/docs/sql-reference/statements/select/into-outfile) - [JOIN](https://clickhouse.com/docs/sql-reference/statements/select/join) - [LIMIT BY](https://clickhouse.com/docs/sql-reference/statements/select/limit-by) - [LIMIT](https://clickhouse.com/docs/sql-reference/statements/select/limit) - [OFFSET](https://clickhouse.com/docs/sql-reference/statements/select/offset) - [ORDER BY](https://clickhouse.com/docs/sql-reference/statements/select/order-by) - [PREWHERE](https://clickhouse.com/docs/sql-reference/statements/select/prewhere) - [QUALIFY](https://clickhouse.com/docs/sql-reference/statements/select/qualify) - [REPLACE](https://clickhouse.com/docs/sql-reference/statements/select/replace-modifier) - [SAMPLE](https://clickhouse.com/docs/sql-reference/statements/select/sample) - [UNION](https://clickhouse.com/docs/sql-reference/statements/select/union) - [WHERE](https://clickhouse.com/docs/sql-reference/statements/select/where) - [WITH](https://clickhouse.com/docs/sql-reference/statements/select/with) - [INSERT INTO](https://clickhouse.com/docs/sql-reference/statements/insert-into) - [CREATE](https://clickhouse.com/docs/sql-reference/statements/create) - [ALTER](https://clickhouse.com/docs/sql-reference/statements/alter) - [DELETE](https://clickhouse.com/docs/sql-reference/statements/delete) - [SYSTEM](https://clickhouse.com/docs/sql-reference/statements/system) - [SHOW](https://clickhouse.com/docs/sql-reference/statements/show) - [GRANT](https://clickhouse.com/docs/sql-reference/statements/grant) - [EXPLAIN](https://clickhouse.com/docs/sql-reference/statements/explain) - [REVOKE](https://clickhouse.com/docs/sql-reference/statements/revoke) - [UPDATE](https://clickhouse.com/docs/sql-reference/statements/update) - [ATTACH](https://clickhouse.com/docs/sql-reference/statements/attach) - [CHECK TABLE](https://clickhouse.com/docs/sql-reference/statements/check-table) - [DESCRIBE TABLE](https://clickhouse.com/docs/sql-reference/statements/describe-table) - [DETACH](https://clickhouse.com/docs/sql-reference/statements/detach) - [DROP](https://clickhouse.com/docs/sql-reference/statements/drop) - [EXISTS](https://clickhouse.com/docs/sql-reference/statements/exists) - [KILL](https://clickhouse.com/docs/sql-reference/statements/kill) - [OPTIMIZE](https://clickhouse.com/docs/sql-reference/statements/optimize) - [RENAME](https://clickhouse.com/docs/sql-reference/statements/rename) - [EXCHANGE](https://clickhouse.com/docs/sql-reference/statements/exchange) - [SET](https://clickhouse.com/docs/sql-reference/statements/set) - [SET ROLE](https://clickhouse.com/docs/sql-reference/statements/set-role) - [TRUNCATE](https://clickhouse.com/docs/sql-reference/statements/truncate) - [EXECUTE AS](https://clickhouse.com/docs/sql-reference/statements/execute_as) - [PARALLEL WITH](https://clickhouse.com/docs/sql-reference/statements/parallel_with) - [USE](https://clickhouse.com/docs/sql-reference/statements/use) - [WATCH](https://clickhouse.com/docs/sql-reference/statements/watch) - [MOVE](https://clickhouse.com/docs/sql-reference/statements/move) - [CHECK GRANT](https://clickhouse.com/docs/sql-reference/statements/check-grant) - [UNDROP](https://clickhouse.com/docs/sql-reference/statements/undrop) - [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) - [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) - [Introduction](https://clickhouse.com/docs/sql-reference) - [Statements](https://clickhouse.com/docs/sql-reference/statements) - [SELECT](https://clickhouse.com/docs/sql-reference/statements/select) - HAVING [Edit this page](https://github.com/ClickHouse/ClickHouse/tree/master/docs/en/sql-reference/statements/select/having.md) # HAVING Clause Allows filtering the aggregation results produced by [GROUP BY](https://clickhouse.com/docs/sql-reference/statements/select/group-by). It is similar to the [WHERE](https://clickhouse.com/docs/sql-reference/statements/select/where) clause, but the difference is that `WHERE` is performed before aggregation, while `HAVING` is performed after it. It is possible to reference aggregation results from `SELECT` clause in `HAVING` clause by their alias. Alternatively, `HAVING` clause can filter on results of additional aggregates that are not returned in query results. ## Example[](https://clickhouse.com/docs/sql-reference/statements/select/having#example "Direct link to Example") If you have a `sales` table as follows: ``` CREATE TABLE sales ( region String, salesperson String, amount Float64 ) ORDER BY (region, salesperson); ``` You can query it like so: ``` SELECT region, salesperson, sum(amount) AS total_sales FROM sales GROUP BY region, salesperson HAVING total_sales > 10000 ORDER BY total_sales DESC; ``` This will list sales people with greater than 10,000 in total sales in their region. ## Limitations[](https://clickhouse.com/docs/sql-reference/statements/select/having#limitations "Direct link to Limitations") `HAVING` can't be used if aggregation is not performed. Use `WHERE` instead. [Previous GROUP BY](https://clickhouse.com/docs/sql-reference/statements/select/group-by) [Next INTERSECT](https://clickhouse.com/docs/sql-reference/statements/select/intersect) - [Example](https://clickhouse.com/docs/sql-reference/statements/select/having#example) - [Limitations](https://clickhouse.com/docs/sql-reference/statements/select/having#limitations) 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=540cbe9d-f7ed-4203-9520-6762d58fe635&pagePath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&origPath=%2Fdocs%2Fsql-reference%2Fstatements%2Fselect%2Fhaving&utm_ga=GA1.1.1950128991.1774535743) © 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▼ - SELECT▼ - [ALL](https://clickhouse.com/docs/sql-reference/statements/select/all) - [APPLY](https://clickhouse.com/docs/sql-reference/statements/select/apply-modifier) - [ARRAY JOIN](https://clickhouse.com/docs/sql-reference/statements/select/array-join) - [DISTINCT](https://clickhouse.com/docs/sql-reference/statements/select/distinct) - [EXCEPT](https://clickhouse.com/docs/sql-reference/statements/select/except) - [EXCEPT](https://clickhouse.com/docs/sql-reference/statements/select/except-modifier) - [FORMAT](https://clickhouse.com/docs/sql-reference/statements/select/format) - [FROM](https://clickhouse.com/docs/sql-reference/statements/select/from) - [GROUP BY](https://clickhouse.com/docs/sql-reference/statements/select/group-by) - [HAVING](https://clickhouse.com/docs/sql-reference/statements/select/having) - [INTERSECT](https://clickhouse.com/docs/sql-reference/statements/select/intersect) - [INTO OUTFILE](https://clickhouse.com/docs/sql-reference/statements/select/into-outfile) - [JOIN](https://clickhouse.com/docs/sql-reference/statements/select/join) - [LIMIT BY](https://clickhouse.com/docs/sql-reference/statements/select/limit-by) - [LIMIT](https://clickhouse.com/docs/sql-reference/statements/select/limit) - [OFFSET](https://clickhouse.com/docs/sql-reference/statements/select/offset) - [ORDER BY](https://clickhouse.com/docs/sql-reference/statements/select/order-by) - [PREWHERE](https://clickhouse.com/docs/sql-reference/statements/select/prewhere) - [QUALIFY](https://clickhouse.com/docs/sql-reference/statements/select/qualify) - [REPLACE](https://clickhouse.com/docs/sql-reference/statements/select/replace-modifier) - [SAMPLE](https://clickhouse.com/docs/sql-reference/statements/select/sample) - [UNION](https://clickhouse.com/docs/sql-reference/statements/select/union) - [WHERE](https://clickhouse.com/docs/sql-reference/statements/select/where) - [WITH](https://clickhouse.com/docs/sql-reference/statements/select/with) - [INSERT INTO](https://clickhouse.com/docs/sql-reference/statements/insert-into) - CREATE▼ - ALTER▼ - [DELETE](https://clickhouse.com/docs/sql-reference/statements/delete) - [SYSTEM](https://clickhouse.com/docs/sql-reference/statements/system) - [SHOW](https://clickhouse.com/docs/sql-reference/statements/show) - [GRANT](https://clickhouse.com/docs/sql-reference/statements/grant) - [EXPLAIN](https://clickhouse.com/docs/sql-reference/statements/explain) - [REVOKE](https://clickhouse.com/docs/sql-reference/statements/revoke) - [UPDATE](https://clickhouse.com/docs/sql-reference/statements/update) - [ATTACH](https://clickhouse.com/docs/sql-reference/statements/attach) - [CHECK TABLE](https://clickhouse.com/docs/sql-reference/statements/check-table) - [DESCRIBE TABLE](https://clickhouse.com/docs/sql-reference/statements/describe-table) - [DETACH](https://clickhouse.com/docs/sql-reference/statements/detach) - [DROP](https://clickhouse.com/docs/sql-reference/statements/drop) - [EXISTS](https://clickhouse.com/docs/sql-reference/statements/exists) - [KILL](https://clickhouse.com/docs/sql-reference/statements/kill) - [OPTIMIZE](https://clickhouse.com/docs/sql-reference/statements/optimize) - [RENAME](https://clickhouse.com/docs/sql-reference/statements/rename) - [EXCHANGE](https://clickhouse.com/docs/sql-reference/statements/exchange) - [SET](https://clickhouse.com/docs/sql-reference/statements/set) - [SET ROLE](https://clickhouse.com/docs/sql-reference/statements/set-role) - [TRUNCATE](https://clickhouse.com/docs/sql-reference/statements/truncate) - [EXECUTE AS](https://clickhouse.com/docs/sql-reference/statements/execute_as) - [PARALLEL WITH](https://clickhouse.com/docs/sql-reference/statements/parallel_with) - [USE](https://clickhouse.com/docs/sql-reference/statements/use) - [WATCH](https://clickhouse.com/docs/sql-reference/statements/watch) - [MOVE](https://clickhouse.com/docs/sql-reference/statements/move) - [CHECK GRANT](https://clickhouse.com/docs/sql-reference/statements/check-grant) - [UNDROP](https://clickhouse.com/docs/sql-reference/statements/undrop) - Operators▼ - Engines▼ - Functions▼ - Formats▼ - [Data Lakes](https://clickhouse.com/docs/sql-reference/datalakes)
Readable Markdown	Allows filtering the aggregation results produced by [GROUP BY](https://clickhouse.com/docs/sql-reference/statements/select/group-by). It is similar to the [WHERE](https://clickhouse.com/docs/sql-reference/statements/select/where) clause, but the difference is that `WHERE` is performed before aggregation, while `HAVING` is performed after it. It is possible to reference aggregation results from `SELECT` clause in `HAVING` clause by their alias. Alternatively, `HAVING` clause can filter on results of additional aggregates that are not returned in query results. ## Example[](https://clickhouse.com/docs/sql-reference/statements/select/having#example "Direct link to Example") If you have a `sales` table as follows: ``` CREATE TABLE sales ( region String, salesperson String, amount Float64 ) ORDER BY (region, salesperson); ``` You can query it like so: ``` SELECT region, salesperson, sum(amount) AS total_sales FROM sales GROUP BY region, salesperson HAVING total_sales > 10000 ORDER BY total_sales DESC; ``` This will list sales people with greater than 10,000 in total sales in their region. ## Limitations[](https://clickhouse.com/docs/sql-reference/statements/select/having#limitations "Direct link to Limitations") `HAVING` can't be used if aggregation is not performed. Use `WHERE` instead.
Shard	89 (laksa)
Root Hash	12633450985039531489
Unparsed URL	com,clickhouse!/docs/sql-reference/statements/select/having s443