A derived table is a transient table that is created dynamically from one or more tables by evaluating a query expression or table expression specified as a subquery within a SELECT statement. You must specify a correlation name for each derived table you create.
The semantics of derived tables and views are identical. See CREATE VIEW in Teradata Vantageā¢ - SQL Data Definition Language Syntax and Examples, B035-1144.