>create table table_name2 as select * from table

what eliminate duplicate without using roenum and not

Question Posted / amar_kondla

5 Answers
10750 Views
Matrix, I also Faced
E-Mail Answers

Answer Posted / amar_kondla

>create table table_name2 as select * from table_name1;

>drop table table_name1;

> rename tabale_name2 to table_name1;

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is foreign key in sql with example?

943

What is query optimization in sql?

990

what is a trigger in mysql? Define different types of trigger. : Sql dba

1078

What is output spooling in sql*plus?

1042

What is cascade in sql?

966

What is difference between primary and secondary key?

1037

What is #table in sql?

1112

What are the different types of dbmss?

1017

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1030

What is parameter substitution in sql?

1036

How to move files from one directory to another in pl sql?

1200

What is a mutating table and a constraining table?

1122

Is crud a cuss word?

1040

What are tables and fields?

1044

How many sql commands are there?

1123