Derived Tables

A derived table is a subquery in the from clause.  It returns a table as its result.  Unlike other subqueries

Derived Tables in From Statement
Derived Tables