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.
| = | Equal |
| Not equal | |
| Less than | |
| Less than or equal | |
| > | Greater than |
| >= | Greater than or equal |
| ALL | BETWEEN |
| DISTINCT | EXISTS |
| IN | LIKE |
| MATCH | NOT IN |
| NOT LIKE | NULL |
| OVERLAPS | SOME, ANY |
| UNIQUE |
