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
Does oracle roll back the transaction on an error?
Is big data nosql?
what are date and time functions in mysql? : Sql dba
What is the difference between the conventional and direct path loads? : aql loader
Which are the different types of indexes in sql?
What is sql profiler in oracle?
How is indexing done in search engines?
how to enter binary numbers in sql statements? : Sql dba
Can ddl statements be used in pl/sql?
Can a select statement fire a trigger?
What is recursive stored procedure?
How do I run a program in pl sql?
Can a foreign key be null?
What is execution plan in sql?
What is record type in pl sql?