To create a table using another table, use the CREATE TABLE AS SELECT statement.

• Use the CREATE TABLE AS SELECT statement to create a new table based on the structure and data of an existing table.

• Spec...read more