15.10 - Derived Tables - 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 derived table is constructed by means of evaluating a table expression over the columns and values of its underlying table set. The semantics of derived tables are identical to those of views. In fact, a view is nothing more than a named derived table.

Derived tables allow you to specify a spool file composed of selected data from the underlying table set supporting the table expression in the FROM list of a query.

See SQL Data Manipulation Language, B035-1146 for complete documentation of derived tables.