Interested to Buy Any Domain ? << Click Here >> for more details...
how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 11977 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 |
What are the limitations of check constraint?
What are advantages fo Stored Procedures?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
How to run queries on external tables?
Point out the difference between user tables and data dictionary?
how to make an oracle object
How to connect to a remote server?
what is the difference between rollback & commit? can a foreign key has null value?
How to run create database statement again?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
What is a Synonym ?
How to use "in" parameter properly?
Oracle General 
