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.

Restriction: For all three forms of a query, you cannot reference both a system-period temporal table and an archive-enabled table in the same query.

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