15.10 - subquery - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)

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.