4. Understanding the Elements of SQL Statements : Predicates in SQL : Comparison Predicate
 
Share this page                  
Comparison Predicate
The syntax for comparison predicates is as follows:
expression_1 comparison_operator expression_2
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).