# Distinct result in elasticsearch

**URL:** https://discuss.elastic.co/t/distinct-result-in-elasticsearch/165342
**Category:** Elasticsearch
**Created:** [January 23, 2019, 6:09am UTC](https://discuss.elastic.co/t/distinct-result-in-elasticsearch/165342 "2019-01-23T06:09:12Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Shubham\_Najardhane](https://avatars.discourse-cdn.com/v4/letter/s/278dde/32.png) [@Shubham\_Najardhane](https://discuss.elastic.co/u/Shubham_Najardhane)
#### Post date: [January 23, 2019, 6:09am UTC](https://discuss.elastic.co/t/distinct-result-in-elasticsearch/165342/1 "2019-01-23T06:09:12Z")

</div>

Hi  
I want to get the list of all the user's email from the elasticsearch.  
Like in mongo engine we can query  
`user_emails = User.objects().distinct("user_email")`  
This results in list like this = ['email1@email.com', 'email2@email.com']

I want to achieve this using elasticsearch. I am using elasticsearch 6.3. Does anyone have any thoughts about this?

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 23, 2019, 7:33am UTC](https://discuss.elastic.co/t/distinct-result-in-elasticsearch/165342/2 "2019-01-23T07:33:30Z")

</div>

A Terms aggregation will give you the most frequent emails.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 20, 2019, 7:33am UTC](https://discuss.elastic.co/t/distinct-result-in-elasticsearch/165342/3 "2019-02-20T07:33:32Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.