Comparison conditions:
Equi (=), Anti (!=, <>, ^=), and Range (<, >, =<, >=).
[NOT] LIKEPattern matching.
[NOT] INSet membership between expressions.
[NOT] EXISTSSet membership producing a Boolean result.
[NOT] BETWEENRange search between two values, inclusive of end points.
ANY, SOME, and ALLSet membership conditions.
IS [NOT] NULLNULL value testcondition.
Logical conditions, in order of precedence:
NOTAn expression being false yields true.
ANDTwo expressions being true yield true.
OROne of two expressions being true yields true.