Chapter 7. Queries

Table of Contents

7.1. Overview

7.2. Table Expressions

7.2.1. The FROM Clause

7.2.2. The WHERE Clause

7.2.3. The GROUP BY and HAVING Clauses

7.2.4. GROUPING SETS , CUBE , and ROLLUP

7.2.5. Window Function Processing

7.3. Select Lists

7.3.1. Select-List Items

7.3.2. Column Labels

7.3.3. DISTINCT

7.4. Combining Queries ( UNION , INTERSECT , EXCEPT )

7.5. Sorting Rows ( ORDER BY )

7.6. LIMIT and OFFSET

7.7. VALUES Lists

7.8. WITH Queries (Common Table Expressions)

7.8.1. SELECT in WITH

7.8.2. Recursive Queries

7.8.3. Common Table Expression Materialization

7.8.4. Data-Modifying Statements in WITH