About Queries and Subqueries

A query is an operation that retrieves data from one or more tables or views. In this reference, a top-level SELECT statement is called a query, and a query nested within another SQL statement is called a subquery.

This section describes some types of queries and subqueries and how to use them. The top level of the syntax is shown in this chapter.

See Also: SELECT for the full syntax of all the clauses and the semantics of the keywords and parameters

select::=

Text description of select

subquery::=

Text description of subquery