6Filtering 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
Nulls Revisited: A Cautionary Note
In the previous two chapters, I discussed the techniques you use to see all the information in a given table. I also discussed how to create and use expressions to broaden or narrow the scope of that information. In this chapter, I’ll show you how to fine-tune what you retrieve by filtering the information using ...
Get SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
