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
Explain about functional dependency and its relation with table design?
What are the different editions of oracle?
Can sub procedure/function be called recursively?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How is it different from a normal table?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How do I reset a sequence in oracle?
How do I know if oracle is installed on windows?
What do you mean by merge in oracle?
What is the difference between count (*), count (expression), count (distinct expression)?
What is the relationship among database, tablespace and data file?
How to write a query with a right outer join in oracle?
How to store only time; not date and time?
How to write a left outer join with the where clause in oracle?
How to load a large xml file?