MINUS Operator

Elastic Stack Elasticsearch
1

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.

2

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