New

The executive guide to generative AI

Read more
About usPartnersSupport|Login
IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« Comparison Operators Math Operators »
Elastic Docs ›Elasticsearch Guide [8.9] ›SQL ›Functions and Operators

Logical Operators

edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.

Logical Operators

edit

Boolean operator for evaluating one or two expressions.

AND

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

OR

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

NOT

edit
SELECT last_name l FROM "test_emp" WHERE NOT emp_no = 10000 LIMIT 5;
« Comparison Operators Math Operators »
Was this helpful?
Feedback