Head First SQL, 2nd Edition

Chapter 3. The Select Statement: Finding Your Information

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 2nd 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].

Finders keepers? When it comes to databases, chances are you’ll need to retrieve your data more often than you’ll need to insert it. In this chapter, you’ll get an up-close look the powerful SELECT statement and learn how to gain access to that important information you’ve been putting in your tables. You’ll even meet the WHERE clause, which will help you selectively get the data you need and avoid displaying the rows you don’t need. So what do you say, let’s get going and find some SQL data.

Searching for a destination

Abby needs to find places that can be reached by car, so she tries the SELECT statement from Chapter 2 to view her table.

Sharpen your pencil