6. Filtering Your Data

“I keep six honest-serving men (They taught me all I knew.) Their names are What and Why and When and How and Where and Who.”

—Rudyard Kipling

“I keep six honest-serving men”

Topics Covered in This Chapter

Refining What You See Using WHERE

Defining Search Conditions

Using Multiple Conditions

Nulls Revisited: A Cautionary Note

Expressing Conditions in Different Ways

Sample Statements


Problems for You to Solve

In the previous two chapters, we discussed the techniques you use to see all the information in a given table. We also discussed how to create and use expressions to broaden or narrow the scope of that information. In this chapter, we’ll show you how to fine-tune what you retrieve by filtering the information ...

Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.