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

can u plz provide me oca sql dumps please i need them

1938

What are the uses of Database Trigger ?

1699

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1127

Can select statements be used on views in oracle?

1022

How to get maxsal , minsal, ename department wise in single query

1543

What happens if recursive calls get out of control?

1068

What is user managed backup in Oracle?

1128

How to put more than 1000 values into an oracle in clause?

1027

What is a lookup table in oracle?

965

How to connect to the server with user account: sys?

1010

Explain what are synonyms used for?

1030

How do I manually create a database in oracle?

1004

What is truncate oracle?

969

How to add a new column to an existing table in oracle?

1127

How to assign query results to variables?

1040