Creating a Table by Using a Subquery

Creating a Table by Using a Subquery :

• Create a table and insert rows by combining the CREATE TABLE statement and the AS subquery option.
• Match the numeric of specified columns to the numeric of subquery columns.
• Define columns with column names and default values.
• CREATE TABLE table [(column, column...)] AS subquery;