>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 is server name sql?

1083

How do you declare a variable in pl sql?

975

Which version of sql do I have?

1008

Are there any features that are decommissioned in 11g that are not present in 11g?

2079

Is not equal in sql?

964

What is rownum in sql?

979

What is a data manipulation language?

971

What is the difference between clustered and non-clustered indexes?

1034

Differentiate between syntax and runtime errors.

1129

How does sql store data?

873

how to create a test table in your mysql server? : Sql dba

956

what is meant by nl2br()? : Sql dba

984

What is trigger and stored procedure in sql?

983

What does rownum mean in sql?

958

How to display Row Number with Records in Oracle SQL Plus?

1002