The SQL Workshop

5. Shaping Data with the WHERE Clause

Overview

In this chapter, we will see how to narrow down the records returned by a query according to specific requirements. We will also see how to search for NULL values. We'll also see how to use the LIKE operator to implement pattern matching. Handling NULL values and empty cells in the results is also covered in this chapter.

Introduction

In the previous chapter, we learned how to extract data from a specific table and sort it. However, in practice, we come across a lot of scenarios where we need to filter our results based on certain criteria and conditions. Consider the example of a table containing the details of all the books available from Packt, from which we want to find the names and ISBNs ...