By Allen G. Taylor

Part of SQL For Dummies Cheat Sheet

Predicates boil down to either a TRUE or a FALSE result. You can filter out unwanted rows from the result of an SQL query by applying a WHERE clause whose predicate excludes the unwanted rows.

Comparison Predicates
= Equal
<> Not equal
< Less than
<= Less than or equal
> Greater than
>= Greater than or equal
Other Predicates
ALL BETWEEN
DISTINCT EXISTS
IN LIKE
MATCH NOT IN
NOT LIKE NULL
OVERLAPS SOME, ANY
UNIQUE