Chapter 14 – Temporary Tables
“I cannot imagine any condition which would cause this ship to founder. Modern shipbuilding has gone beyond that.”
- E. I. Smith, Captain of the Titanic
CREATING A Derived Table
•Exists only within a query
•Materialized by a SELECT Statement inside a query
•Space comes from the User’s Spool space
•Deleted when the query ends
The SELECT Statement that creates and populates the Derived table is always inside Parentheses.
The Three Components of a Derived Table
A derived table will always have a SELECT query to ...