16.20 - subquery - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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.