Queries

A query specifies a result table or an intermediate table. A query is a component of certain SQL statements.

A query can have one of the following forms:

• subselect
• fullselect
• select-statement

A subselect is a subset of a fullselect, and a fullselect is a subset of a select-statement.

Another SQL statement that can be used to retrieve at most a single row is described in SELECT INTO statement. SELECT INTO is not a subselect, fullselect, or a select-statement.