This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.

› › ›

Logical Operators

edit

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 »