The Where clause allows us to pull out more specific information from our database.
When to use
Anytime you want to pull out specific information, use the where clause.
Where clauses go at the end of your SQL statement and allow you to pull out specific information using comparison operators.
For example: WHERE [Age] > 21
<> Not Equal
> Greater Than
< Less Than
>= Greater Than or Equal To
<= Less Than or Equal To
Hints & tips
- Use comparison operators with your WHERE clause to pull out specific information.
Lesson notes are only available for subscribers.