# Query DSL for count distinct **URL:** \ **Category:** Elasticsearch\ **Created:** [November 11, 2013, 2:17pm UTC](https://discuss.elastic.co/t/query-dsl-for-count-distinct/14352 "2013-11-11T14:17:56Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Bruno\_Galindro\_da\_Co](https://avatars.discourse-cdn.com/v4/letter/b/59ef9b/32.png) [@Bruno\_Galindro\_da\_Co](https://discuss.elastic.co/u/Bruno_Galindro_da_Co)\ **Post date:** [November 11, 2013, 2:17pm UTC](https://discuss.elastic.co/t/query-dsl-for-count-distinct/14352/1 "2013-11-11T14:17:56Z")
How can I exec this SQL query is ES Query DSL? select count(distinct column) from table How Can I display it with Kibana? Which Pannel I need to use to display this count? -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:07am UTC](https://discuss.elastic.co/t/query-dsl-for-count-distinct/14352/2 "2017-07-06T02:07:51Z")