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    
ALLBETWEEN
DISTINCTEXISTS
INLIKE
MATCHNOT IN
NOT LIKENULL
OVERLAPSSIMILAR
SOME, ANYUNIQUE
































Other Predicates    
ALLBETWEEN
DISTINCTEXISTS
INLIKE
MATCHNOT IN
NOT LIKENULL
OVERLAPSSIMILAR
SOME, ANYUNIQUE








dummies

Source:http://www.dummies.com/how-to/content/sql-where-clause-predicates.html

No comments:

Post a Comment