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 |
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is oracle rownum?
What is blob data type in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
what is difference between cartesian join & cross join even they give same result?
Give syntax for SQL and ORACLE joins.
what is the output of select * from emp where null=null & select * from emp where 1=1
What is blob datatype?
What the is the diff between local index and global index. give some example.
How can we force the database to use the user specified rollback segment?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to fetch the row which has the max value for a column?