Derived table

A derived table is a table created as a result of the evaluation of a query expression. Unlike base tables and views, a derived table has no name. The values in the derived table are taken from the values in the underlying tables at the time the query expression is evaluated.