4. Understanding the Elements of SQL Statements : SQL Operators : Comparison Operators
 
Share this page                  
Comparison Operators
Comparison operators compare two expressions. SQL includes the following comparison operators:
Comparison Operator
Description
=
Equal to
<>
Not equal to
>
Greater than
>=
Greater than or equal to
<
Less than
<=
Less than or equal to
The <> operator can also be specified as != or ^=.
All comparison operators are of equal precedence.
The equal sign (=) also serves as the assignment operator in assignment operations (see page Assignment Operations).