Comparison Operators

Comparison operators are used in the WHERE clause to determine which records to select.

Comparison Operator Description
= Equal
<> Not Equal
!= Not Equal
> Greater Than
>= Greater Than or Equal
< Less Than
<= Less Than or Equal
IN Matches a value in a list
NOT Negates a condition
BETWEEN Within a range (inclusive)
EXISTS Condition is met if subquery returns at least one row

[//]: #