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 | SIMILAR |
SOME, ANY | UNIQUE |
ALL | BETWEEN |
DISTINCT | EXISTS |
IN | LIKE |
MATCH | NOT IN |
NOT LIKE | NULL |
OVERLAPS | SIMILAR |
SOME, ANY | UNIQUE |
dummies
Source:http://www.dummies.com/how-to/content/sql-where-clause-predicates.html
No comments:
Post a Comment