create table newtable as select * from oldtable order by dupcol; drop oldt

how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used

Question Posted / kishor solanki @ 9904762204

Answer Posted / kishor solanki @ 9904762204

create table newtable as select * from oldtable order by dupcol;
drop oldtable;
rename newtable to oldtable;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does pl/sql support create command?

1043

What does 0 mean in sql?

910

How do I truncate a word?

996

What is output spooling in sql*plus?

982

How would you reference column values before and after you have inserted and deleted triggers?

1014

What are hotfixes and patches?

885

What does select count (*) mean in sql?

961

What does count (*) mean in sql?

1514

How do I trace sql profiler?

919

What are database links used for?

988

What are some predefined exceptions in pl/sql?

1062

What has stored procedures in sql?

991

How do I filter in sql profiler?

947

What is posting?

990

tell us something about heap tables. : Sql dba

1047