Interested to Buy Any Domain ? << Click Here >> for more details...
how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 11590 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 |
Can we commit inside a function in oracle?
State some uses of redo log files?
What is cluster Key ?
Explain a data segment?
difference between bind variable and variable
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
Can you assign multiple query result rows to a variable?
Why is oracle so popular?
What is a Database instance ? Explain?
What are the built-in functions used for sending Parameters to forms ?
What do you mean by cdb and pdb in oracle 12c?
what is the syntax of UPDATE command?
Oracle General 
