“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
• 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.
A derived table will always have ...