Skip to Main Content
The SQL Workshop
book

The SQL Workshop

by Frank Solomon, Rakesh Kumar Pandey, Shubham Jain, Prashanth Jayaram, Awni Al Saqqa, Fiodar Sazanavets, Aaditya Pokkunuri, Shashikant Shakya, Dixit Patel, Pradeep Kumar Gupta, Scott Cosentino
December 2019
Beginner content levelBeginner
288 pages
4h 48m
English
Packt Publishing
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL for Business Users

SQL for Business Users

O'Reilly Media, Inc.
SQL Antipatterns

SQL Antipatterns

Bill Karwin

Publisher Resources

ISBN: 9781838642358Supplemental Content