There are many comparison operators that you can use in a WHERE clause:
The following table lists the comparison operators.
OperatorDescription
=Equal
or !=Not equal
Less than
Greater than
Less than or equal
=Greater than or equal
ANYCompares one value with any value in a list
ALLCompares one value with all values in a list