The WHERE Clause

The WHERE Clause: The WHERE Clause: an overview, Types of Filters, Using Multiple Condition Filters.

Updated

  1. The WHERE Clause: an overview (Novice): Add a WHERE clause to return only the rows that match a condition, such as customers in the UK.
  2. Types of Filters (Apprentice): Filter numbers and dates with comparison operators, and text with LIKE and its % and _ wildcards.
  3. Using Multiple Condition Filters (Apprentice): Combine conditions in a WHERE clause with AND and OR, and use parentheses so they're checked the way you mean.