# How to fetch the distinct records from Elastic Search

**URL:** <https://discuss.elastic.co/t/how-to-fetch-the-distinct-records-from-elastic-search/14583>\
**Category:** Elasticsearch\
**Created:** [November 25, 2013, 7:27pm UTC](https://discuss.elastic.co/t/how-to-fetch-the-distinct-records-from-elastic-search/14583 "2013-11-25T19:27:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sowjanya](https://avatars.discourse-cdn.com/v4/letter/s/fbc32d/32.png) [@sowjanya](https://discuss.elastic.co/u/sowjanya)\
**Post date:** [November 25, 2013, 7:27pm UTC](https://discuss.elastic.co/t/how-to-fetch-the-distinct-records-from-elastic-search/14583/1 "2013-11-25T19:27:25Z")

</div>

How to fetch the distinct records from Elastic Search.

Eg:  
field1 field2 field3  
1 abc xyz  
2 abc def  
3 abc pqr

Now,iam searhing for xyz OR def OR pqr. For these records field2 value is same.  
now,Iam getting the 3 records(abc,abc,abc). But,I need only one record(abc).

How,can i query for getting the distinct Results.

Please help me.  
Thanks in Advance.

---

<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:** [July 6, 2017, 2:04am UTC](https://discuss.elastic.co/t/how-to-fetch-the-distinct-records-from-elastic-search/14583/2 "2017-07-06T02:04:54Z")

</div>