Suppose Table name is Dup_Del with id as a column(consists 10,20,30,10,10,

There is a big table with "n" of rows and 40 + columns .It
doesn't have primary key.How do you select the primary key.
In other words how do you get the duplicate records.

Question Posted / harikanth

2 Answers
5900 Views
Microsoft, I also Faced
E-Mail Answers

Answer Posted / harikanth

Suppose Table name is Dup_Del with id as a column(consists
10,20,30,10,10,30,20)then

select * from Dup_Del
where rowid not in(select * from
(select min(rowid) from Dup_Del
group by id
);
the above query will give you the duplicate records. if you
want unique records then

select * from Dup_Del
where rowid in(select * from
(select min(rowid) from Dup_Del
group by id
);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is open database communication (odbc) in oracle?

948

What is Trigger in Oracle?

1074

How to use regular expression in pattern match conditions in oracle?

975

Is there a function to split a string in plsql?

981

What is archive log in Oracle?

1069

How to retrieve data from an explicit cursor?

1007

What is coalesce function?

1003

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1849

How to get execution path reports on query statements?

927

how to do daily transactions with out sql* loader control file regesterd in apps?

1626

How to connect asp pages to oracle servers?

1004

What do you mean by merge in oracle and how can you merge two tables?

905

What is a oracle database?

992

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1871

How do I escape a reserved word in oracle?

1130