how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 10902 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Respected sir, Please send me technical questions related to oracle apps..
What is oracle update statement with inner join ?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to check the oracle tns settings?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What is the difference between translate and replace in oracle?
Can sub procedure/function be called recursively?
What is an oracle data file?
What to do if the startbd.bat failed to start the xe instance?
What is an oracle database table?
What is oracle server autotrace in oracle?
Explain the difference between sap and oracle?
Explain the use of Merge statement in oracle 11g
What is dynamic proxy?
What is a dead lock in oracle?
