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

7. Subqueries, Cases, and Views

Overview

In this chapter, we will look at some techniques that will help us add logic to our existing queries using CASE statements. We will also query data present in multiple tables using subqueries. We will also create views using queries that allows us the flexibility to create a temporary table to run queries on.

Introduction

In the previous chapter, we saw how the various types of SQL joins can connect multiple tables in a single SELECT query. This powerful technique gives us fine-grained control over the data that our SQL queries return. However, SQL offers much more. In this chapter, we'll use the PACKT_ONLINE_SHOP database to see how subqueries, CASE statements, and views boost the flexibility and ...

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