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

The derived table allows the FROM list to specify a spool file composed of selected data from underlying tables. The derived table acts like a viewed table.

Derived tables are valid when coded as part of a seed query.

Derived tables are never valid when coded as part of a recursive query.

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