The WHERE Clause

The WHERE clause is optional. When it's used, it acts as a filter on the rows of the result set produced by the FROM clause

Topics include the following:

  • Conditions
  • Shopping Carts
  • Operators
  • Compound Conditions with AND and OR
  • IN Conditions
  • Correlated Subqueries
  • EXISTS Conditions
  • WHERE Clause Performance
  • Wrapping Up: the WHERE Clause



Visit Website

Code Archive

Sample Applications & Examples

Simply SQL

Publisher: SitePoint

Author: Rudy Limeback

Year: 2008