NOTE: You are looking at documentation for an older release. For the latest information, see the current release documentation.
Logical Operators
editLogical Operators
editBoolean operator for evaluating one or two expressions.
AND
editSELECT last_name l FROM "test_emp" WHERE emp_no > 10000 AND emp_no < 10005 ORDER BY emp_no LIMIT 5;
OR
editSELECT last_name l FROM "test_emp" WHERE emp_no < 10003 OR emp_no = 10005 ORDER BY emp_no LIMIT 5;
NOT
editSELECT last_name l FROM "test_emp" WHERE NOT emp_no = 10000 LIMIT 5;