One of the main roles of a DBMS is to store data. The other main role is to retrieve it. To retrieve data, you use the SELECT statement. However, you often don’t want all the data, so you will want to filter the results.
In this chapter, we’ll look at how you filter your requests with a WHERE clause. As we do, we’ll cover important topics such as
How the WHERE clause works
Working with missing values
Working with different data types: numbers, strings, and dates
Combining filters
Working with “wildcards”
If you have ...
