Interested to Buy Any Domain ? << Click Here >> for more details...
how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 11817 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 |
How to create a new table in oracle?
What is the usage of merge statement?
What do you mean by merge in oracle?
Explain the truncate in oracle?
What is tns entry?
Why do you create or replace procedures rather that drop and recreate.
What are the different types of synonyms?
How to count groups returned with the group by clause in oracle?
difference between oracle8i and oracle9i
What is the order of defining local variables and sub procedures/functions?
How to define a cusotmer as a supplier in ORACLE R12
What is oracle rowcount?
Oracle General 
