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
How do I know if oracle client is installed on windows?
How to create an oracle database manually?
How to enter a new row into a table interactively?
What is meant by an index?
What happens to the current transaction if the session is ended?
What is oracle used for?
How to declare a local variable?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to get execution statistics reports on query statements?
How to define a data field as not null?
How to speed up webrick?
How can we view last record added to a table?
How to commit the current transaction in oracle?
What are the oracle differences between nvl and coalesce
How to pass a parameter to a cursor in oracle?