Interested to Buy Any Domain ? << Click Here >> for more details...
how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 11979 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
What are the benefits of ordbms?
What is varray?
How to experiment a data lock in oracle?
What is a connect identifier?
How to convert characters to dates in oracle?
Why should I use oracle database?
How can you use check constraints for self referential integrity?
Explain the use of rows option in imp command.
How to load data from external tables to regular tables?
How many anonymous blocks can be defined?
Is oracle a language?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain what are synonyms used for?
Can we insert data in view oracle?
What is the difference between I and G in Oracle?
