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

7.5. Sorting Rows

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. Data-Modifying Statements in WITH