Description | Example |
Simple predicate | salary BETWEEN 10000 AND 20000 |
Predicate with NOT operator | edept NOT LIKE 'eng_%' |
Predicates combined using OR operator | edept LIKE 'eng_%' OR edept LIKE 'admin_%' |
Predicates combined using AND operator | salary BETWEEN 10000 AND 20000 AND edept LIKE 'eng_%' |
Predicates combined using parentheses to specify evaluation | (salary BETWEEN 10000 AND 20000 AND edept LIKE 'eng_%') OR edept LIKE 'admin_%' |
AND | true | false | unknown |
true | true | false | unknown |
false | false | false | false |
unknown | unknown | false | unknown |
OR | true | false | unknown |
true | true | true | true |
false | true | false | unknown |
unknown | true | unknown | unknown |