Using Temporary Tables in SQL Statements

Temporary tables can be used in the SQL statement wherever the regular tables can be ... Create a temporary table named Temp1 with two columns ... SELECT deptnum, count(*) as NumEmployees.

devzone.advantagedatabase.com