Interested to Buy Any Domain ? << Click Here >> for more details...
how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 11826 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 |
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
Can we create trigger on materialized view in oracle?
What is a nvl function?
How to drop an index in oracle?
26. Display the earliest shipping date in the format: DD/MON/YYYY
How many memory layers are in the oracle shared pool?
What are the commands youd issue to show the explain plan for select
What is Index Cluster ?
what is the difference between UNION AND UNIONALL
Difference between cartesian join and cross join?
How to get execution path reports on query statements?
Can you use a commit statement within a database trigger?
Oracle General 
