>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 the difference between syntax error and runtime error?

1065

When are we going to use truncate and delete?

925

What is a temporal data type?

979

How to create an array in pl/sql?

1009

What is cte?

923

Show the two pl/sql cursor exceptions.

1104

What are the sql versions?

893

Define tables and fields in a database

1080

What are the types of dbms?

920

What is difference between sql and mysql?

1064

what is sql profiler? : Sql dba

995

What is data type in database?

931

Why is sql better than hql?

920

What is the largest value that can be stored in a byte data field?

956

What is the left table in sql?

914