>create table table_name2 as select * from table

what eliminate duplicate without using roenum and not

Question Posted / amar_kondla

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

Please Help Members By Posting Answers For Below Questions

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

1008

how to get a list of all tables in a database? : Sql dba

1030

What is the need of merge statement?

1092

Does user triggers have entry for trigger with compilation errors?

1091

What is record in pl sql?

1140

What is cursor and why it is required?

1256

Explain what is sql*plus?

1196

How many functions are there in sql?

1095

Can we use the cursor's to create the collection in PL/SQL?

1093

What does the acronym acid stand for in database management?

1089

What is auto increment?

1045

What is use of package in pl sql?

1070

Is sql an operating system?

1075

What are predefined functions in sql?

1108

What are different functions in sql?

998