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 |
How do I manually create a database in oracle?
Explain the characteristics of oracle dba?
Explain the blob datatype?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
What happens if you use a wrong connect identifier?
How to calculate date and time differences in oracle?
What is a nvl function? How can it be used?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What are data pump export and import modes?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
query optmization techniques and quwry analyser+projects+ppts