How to create a new table from old table

Опубликовано: 20 Июнь 2026
на канале: Computer Science lectures and tutorials
437
1

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