Chapter 7. Queries

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

Historical version. PostgreSQL 12 has reached end of support. 2024-11-21. See the current manual.

Chapter 7. Queries
Prev	Up	Part II. The SQL Language	Home	Next

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

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.

Prev	Up	Next
6.4. Returning Data from Modified Rows	Home	7.1. Overview

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.