NOTE: You are looking at documentation for an older release. For the latest information, see the current release documentation.
Logical Operatorsedit
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;