15.10 - subquery - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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 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 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.