Which of the following queries is used to copy data from one table into another table when both the the tables are existing and the table structures are same?
select * from first-table-name into second-table-name
insert into destination-table-name select * from source-table-name
insert into destination-table-name values select * from source-table-name
insert into destination-table-name values ( select * from source-table-name )
Create a table with the name emp1 with the same structure as employees table . Execute the below command for copying data from employees into emp1 .
Insert into emp1 select * from employees
select * into new_table_name from old_table_name;
This will also do.
Devesh Your query will create new table. But the question is about inserting data into one table from another table when the destination table is existing . Hence Question and answer both are correct.
Back To Top