create table emp_dup as select * from emp: if we have already structure

How to copy a table in another table with datas?

Question Posted / mohan

Answer Posted / mohan

create table emp_dup as select * from emp:

if we have already structure means:

Insert into emp_dup(select * from emp);

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I kill a query in postgresql?

1182

What is delete command in sql?

1170

how to rename an existing column in a table? : Sql dba

1075

What is exception? What are the types of exceptions?

1112

What normalization means?

1014

how to create a new table by selecting rows from another table in mysql? : Sql dba

1163

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1242

what happens if you no create privilege in a database? : Sql dba

1045

What is the meaning of disabling a trigger?

1236

How to add a column ‘salary’ to a table employee_details?

1052

Can you upgrade sql express to full sql?

1141

Define commit, rollback and savepoint?

1079

What program will open a mdb file?

1015

What is the purpose of my sql?

1008

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1063