CREATE TABLE AS SELECT creates a new table based on the output of a SELECT statement. CTAS is the simplest and fastest way to create a copy of a table. CREATE TABLE AS SELECT (CTAS) is one of the most ...