Interested to Buy Any Domain ? << Click Here >> for more details...
how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 11778 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 load excel data sheet to oracle database
How to bring a tablespace online?
pls explain connect by prior with example and its real time use
What are the data types in oracle?
how do u know the total no of rows in a table?
What is the minimum client footprint required to connect c# to an oracle database?
What is a Shared SQL pool ?
How to call a stored function with parameters?
How to count duplicated values in a column in oracle?
How to start instance with a minimal initialization parameter file?
What are advantages fo Stored Procedures?
How to write a query with a full outer join in oracle?
Oracle General 
