how to find find & delete duplicate rows from two different
tables?
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 is control file used for?
What is the difference between pre-select and pre-query?
What is the relation of a user account and a schema?
How to use "if" statements on multiple conditions?
What is parameterized cursor in oracle?
What is the max number of columns in an oracle table?
What is the oracle implicit cursor?
What do you know about normalization? Explain in detail?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How to convert characters to numbers in oracle?
Why do you use stored procedures and state some of its disadvantages?
What is the difference between Delete, Truncate and Drop in Oracle?
What is the use of aggregate functions in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
What happens if the imported table already exists?