how to delete all duplicate records from a table using
subquery?
Answer Posted / edara satish
delete from
<<table_name>>
where rowid in
(select a.rowid
from <<table_name a,table_name b>>
where a.colname = b.colname
b.colname2 = b.colname2
......
...
a.colnamen = colnamen
order by .... desired colnames)
Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is a database table in oracle?
Explain what are clusters?
Explain overloading. Can functions be overloaded?
How to check your oracle database 10g xe installation?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How do we get field details of a table?
Name the various constraints used in oracle?
How translate command is different from replace?
What is Segment Advisor in Oracle?
Respected sir, Please send me technical questions related to oracle apps..
What are internal user account in oracle?
What are the different types of partitions in oracle?
How to count duplicated values in a column in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?