using rownum . Select * from (Select name,id, Row

how to find find & delete duplicate rows from two different
tables?

Question Posted / paks

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

Please Help Members By Posting Answers For Below Questions

How can we delete duplicate rows in a table?

979

How to define and use table alias names in oracle?

946

What is blob datatype?

1134

what is normalisation?what are its uses?

2278

How to rename an index?

1076

How many types of tables are there in oracle?

1062

What is a cursor in oracle?

1182

Explain the use of log option in exp command.

1124

What is the disadvantage of User defind function?

2296

How do I find my oracle client driver version?

1046

what is IDE,DMV in sql server?

2829

What is the difference between $oracle_base and $oracle_home?

1090

What is a select query statement in oracle?

972

Explain the importance of .pll extension in oracle?

1013

How to use "in" parameter properly?

1077