Teradata Temporary Tables: A Guide to Derived and Volatile Tables
Introduction to Teradata Temporary Tables This article highlights the distinct types and uses of Teradata temporary tables. 1. Derived Tables To avoid syntax errors, tables derived from queries should always be named alias. Here is a derived table example (in parentheses): SELECT * FROM (SELECT MAX(Revenue) FROM Invoices) AS InvoiceRevenue (MaxRevenue); The table is labeled …