SQL WHERE Clause Predicates
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 |
SIMILAR |
| SOME, ANY |
UNIQUE |
Other Predicates
| ALL |
BETWEEN |
| DISTINCT |
EXISTS |
| IN |
LIKE |
| MATCH |
NOT IN |
| NOT LIKE |
NULL |
| OVERLAPS |
SIMILAR |
| SOME, ANY |
UNIQUE |
