HCLTech Interview Question
how to copy one table data to another in SQL?
Interview Answer
Anonymous
Jan 10, 2018
create table copied_table_name as select * from original_table; --will copy all data from original table create table copied_table_name as select * from original_table where 1<0; --will copy only structure from original table