Advertisement
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 All-in-One For Dummies Cheat Sheet

The WHERE clause is an SQL filter that passes rows that meet the search condition and rejects rows that don't meet the condition. By including WHERE clauses in your SQL SELECT statements, you can restrict the rows that you place into the resulting table to those that satisfy specific conditions. The following table lists the predicates to use to filter for the information you want:

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
  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!