>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

Is sql an operating system?

1020

How much does sql cost?

1006

Is time a data type in sql?

909

what are all the common sql function? : Sql dba

1058

What is difference between stored function and application function?

1204

How does postgresql compare to oracle/db2/ms sql server/informix?

1034

Can we use joins in subquery?

1165

explain access control lists. : Sql dba

1002

What is linq to sql?

1133

What are the different sql commands?

1073

What are the different types of functions in sql?

1055

Is t sql a programming language?

1069

Which is better trigger or stored procedure?

950

What is cross join sql?

917

what is cross join? : Sql dba

997