Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

SQL WHERE Clause Predicates

Part of the 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 SIMILAR
SOME, ANY UNIQUE
Other Predicates    
ALL BETWEEN
DISTINCT EXISTS
IN LIKE
MATCH NOT IN
NOT LIKE NULL
OVERLAPS SIMILAR
SOME, ANY UNIQUE
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus

SERIES
SQL For Dummies Cheat Sheet

Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.