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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does oracle roll back the transaction on an error?

784


Is big data nosql?

724


what are date and time functions in mysql? : Sql dba

745


What is the difference between the conventional and direct path loads? : aql loader

950


Which are the different types of indexes in sql?

794


What is sql profiler in oracle?

788


How is indexing done in search engines?

741


how to enter binary numbers in sql statements? : Sql dba

736


Can ddl statements be used in pl/sql?

819


Can a select statement fire a trigger?

922


What is recursive stored procedure?

852


How do I run a program in pl sql?

731


Can a foreign key be null?

823


What is execution plan in sql?

800


What is record type in pl sql?

779