Head First SQL, 2nd Edition

Chapter 4. Better Where Clauses Filtering Rows

A Note for Early Release Readers

With Early Release ebooks, you get books in their earliest form—the author’s raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 4th chapter of the final book. Please note that the GitHub repo will be made active later on.

If you have comments about how we might improve the content and/or examples in this book, or if you notice missing material within this chapter, please reach out to the editor at [e-mail].

Figure 4-1.  

Here’s your opportunity to dig in. You’ve already tried out WHERE for simple table row filters, but now you can perform an in-depth exploration of WHERE to see what it can really do.

In this chapter, you’ll use AND to find rows that meet two or more requirements. You’ll switch to OR if you want rows that satisfy any of several conditions. And you will even unearth new keyword artifacts to aid in your quest for missing items, ranges of values, or text patterns.

So what are you waiting for? Turn the page and let the excavation begin. WHERE is your new best friend.

Misplaced identification

Uh oh, Abby doesn’t look happy. Let’s check back in with her to see what’s going on.

Figure 4-2.  

We can use a SELECT query with the filter: WHERE country = 'USA'

to find Abby some ...