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 SQL statements, a referenced table can be a base table, a derived table, a queue table, or a view. The semantics of derived tables and views are identical.
A derived table is the result of a subquery of one or more other tables.
This option enables the FROM clause to specify a spool made up of selected data from an underlying table set. The derived table is similar to a viewed table.
You can invoke a scalar UDF from any point in a derived table.
ANSI Compliance
Derived tables are ANSI SQL:2011-compliant.