how to find find & delete duplicate rows from two different
tables?
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 |
Does rowid change in oracle?
Explain alias?
what are different types of deletes?
Explain what are the type of synonyms?
What is a heap related to database ?
1 Answers TCS, University of Edinburgh,
what is reindexing?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How many categories of data types?
Describe the different type of Integrity Constraints supported by ORACLE ?
How to delete all rows a table in oracle?
how to get last monday of a month?
how to do daily transactions with out sql* loader control file regesterd in apps?