# MINUS Operator

**URL:** <https://discuss.elastic.co/t/minus-operator/145395>\
**Category:** Elasticsearch\
**Created:** [August 21, 2018, 1:21pm UTC](https://discuss.elastic.co/t/minus-operator/145395 "2018-08-21T13:21:01Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![prabhu-ch](https://avatars.discourse-cdn.com/v4/letter/p/6f9a4e/32.png) [@prabhu-ch](https://discuss.elastic.co/u/prabhu-ch)\
**Post date:** [August 21, 2018, 1:21pm UTC](https://discuss.elastic.co/t/minus-operator/145395/1 "2018-08-21T13:21:01Z")

</div>

Hi ,  
I am searching for "MINUS" Operator example.

POST \_xpack/sql  
{  
"query":"SELECT user as t FROM my\_index WHERE activity = 1 MINUS SELECT user as t FROM my\_index WHERE activity = 2 "  
}

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:** [September 18, 2018, 1:21pm UTC](https://discuss.elastic.co/t/minus-operator/145395/2 "2018-09-18T13:21:02Z")

</div>

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