Answers for "creating a table from an existing table"

create a table from one field of another table

SQL> CREATE TABLE SALARY AS
   SELECT ID, SALARY
   FROM CUSTOMERS;

Posted by: Guest on July-09-2020

sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;

Posted by: Guest on December-07-2020

Code answers related to "creating a table from an existing table"