how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 10573 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pravin jadhav
delete from table_name where rowid not in (select max(rowid) from table group by
duplicate_values_field_name);
or
delete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from
table_name tb where ta.dv=tb.dv);
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / paks
using rownum .
Select * from
(Select name,id, Row_number () over (partition by name order by id desc) rn from tblname)
Where rn=1;
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / k.sailesh
We can find duplicate rows from two tables by using select *
from table name. it displays all the values repeated and unique.
We can delete duplicate rows by using Primary key constraint.
| Is This Answer Correct ? | 3 Yes | 17 No |
when do u go for hash partitioning?
How to use an explicit cursor without open statements?
How do I spool in oracle?
what is normalisation?what are its uses?
When can Hash Cluster used ?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
What is a cluster Key ?
Give the various exception types.
what is the difference between no rows returned and null returned?
Give the various rollback segment states.
What are operators in oracle?
What is a shared pool?
Oracle General 
