Chapter 6. SELECT Statements, Table Expressions, and Subqueries
Introduction
The SELECT statement and the table expression have already been introduced in this book. These two language constructs are both used for querying data. Within SQL, some other constructs exist, such as the subquery and select block, that are also relevant for querying data. All these constructs have a strong mutual relationship that makes it difficult to keep them apart. However, for someone who is programming SQL, it is important to know the differences. That is why we devote this entire chapter to them. For each construct, we describe what is meant exactly and what the mutual relationships are.
We begin with the SELECT statement. In the preceding chapters, we have already ...
Get Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary 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.
