create table as select
How to create new table from old table
How to copy datas from one table to another table
This query will create a new table copy all contents from old table.
the syntax is
select column list into new-able-name from old-table-name where condition;
ex:
select * into temp_dup from temp;
Like us on FB
https://www.facebook.com/Eddy5SmartSo...
Subscribe Our Channel
/ @computersciencelecturesand4191