Query languageΒΆ

The Data Query Language (DQL) is used to retrieve data with the SELECT statement. Its complete syntax is shown in the following diagram:

WITH withClause SELECT selectClause FROM source INNER JOIN LEFT RIGHT OUTER JOIN source ON joinCondition USING ( column(s) ) WHERE whereClause GROUP BY groupByClause HAVING havingClause ORDER BY orderByClause WITH CONTINUATION continuation

The pages in this section cover the individual parts of the SELECT statement, listed in the order in which they appear.