The syntax for comparison predicates is as follows:

In a comparison predicate, expression2 can be a subquery. If expression2 is a subquery and does not return any rows, the comparison predicate evaluates to false. For information about subqueries, see Subqueries (see Subqueries in the WHERE Clause). For details about comparison operators, see Comparison Operators (see Comparison Operators).