how to delete all duplicate records from a table using
subquery?
- 7 Answers
- 21933 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
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 the difference between sap and oracle?
What are the different types of trigger and explain its various uses and functions?
What is a view and how is it different from a table?
what is the difference between substr and instr function in oracle?
How to define an anonymous block?
How to recover a dropped table in oracle?
How to assign values to variables?
Can you have more than one content canvas view attached with a window ?
Explain the use of rows option in imp command.
Does oracle partitioning improve performance?
11. Display the client number and name and the client number and name of the person who referred that client.
What are the set operators union, union all, minus & intersect meant to do?
What is oracle thin client?
How to create a single index for multiple columns?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
