Answer Posted / guest
If new table is not yet created,
create table new_table as select * from old_table;
if new table is already created,
insert into new table select * from old_table
provided the structure of the new table is same as old
table.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of the primary key?
How many joins can you have in sql?
Which is better varchar or nvarchar?
What are different types of functions in sql?
What are different methods to trace the pl/sql code?
Does sqlite need a server?
When to use inner join and left join?
How do you create an update query?
Is sql microsoft?
How long does it take to learn pl sql?
What are the set operators in sql?
How to write a query to show the details of a student from students table whose
what are tables and fields? : Sql dba
What does inner join mean?
What is difference between ms sql and mysql?