16.20 - subquery - Teradata Database - Teradata Vantage NewSQL Engine

A SELECT request that defines the derived table.

You cannot specify the TOP n or TOP m PERCENT options (see “TOP n” and “TOP m PERCENT” later in this table, and Teradata Vantage™ SQL Data Manipulation Language , B035-1146 ) in a subquery.

You cannot specify an ORDER BY clause in the subquery specification of a CREATE VIEW request.

AS

An optional introductory clause to derived table name.

derived_table_name

The name of a derived table.

For information about naming database objects, see Teradata Vantage™ SQL Fundamentals, B035-1141.

column_name

A column name for a member of the set of all column names specified in the subquery select list.

Specify only an unqualified column name here; do not use fully qualified forms such as the following:

•   databasename.tablename.columnname

•   tablename.columnname.