原英文版地址: https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-operators-logical.html, 原文档版权归 www.elastic.co 所有
本地英文版地址: ../en/sql-operators-logical.html
本地英文版地址: ../en/sql-operators-logical.html
重要: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 当前版本文档。
Logical Operatorsedit
Boolean operator for evaluating one or two expressions.
ANDedit
SELECT last_name l FROM "test_emp" WHERE emp_no > 10000 AND emp_no < 10005 ORDER BY emp_no LIMIT 5;
ORedit
SELECT last_name l FROM "test_emp" WHERE emp_no < 10003 OR emp_no = 10005 ORDER BY emp_no LIMIT 5;
NOTedit
SELECT last_name l FROM "test_emp" WHERE NOT emp_no = 10000 LIMIT 5;