Queries

Table of Contents

Overview

Table Expressions

 The FROM Clause

 The WHERE Clause

 The GROUP BY and HAVING Clauses

 Window Function Processing

Select Lists

 Select-List Items

 Column Labels

 DISTINCT

Combining Queries (UNION, INTERSECT, EXCEPT)

Sorting Rows (ORDER BY)

LIMIT and OFFSET

VALUES Lists

WITH Queries (Common Table Expressions)

SELECT in WITH

 Recursive Queries

 Common Table Expression Materialization

 Data-Modifying Statements in WITH

The previous chapters explained how to create tables, how to fill them with data, and how to manipulate that data. Now we finally discuss how to retrieve the data from the database.