Docs
-->
Elasticsearch Reference [7.0] » SQL access » Functions and Operators » Logical Operators
«  Comparison Operators     Math Operators  »

Logical Operators

Boolean operator for evaluating one or two expressions.

AND

SELECT last_name l FROM "test_emp" WHERE emp_no > 10000 AND emp_no < 10005 ORDER BY emp_no LIMIT 5;

OR

SELECT last_name l FROM "test_emp" WHERE emp_no < 10003 OR emp_no = 10005 ORDER BY emp_no LIMIT 5;

NOT

SELECT last_name l FROM "test_emp" WHERE NOT emp_no = 10000 LIMIT 5;
«  Comparison Operators     Math Operators  »