OraFAQ Forum: Server Administration » Deleting duplicate rows

Home » RDBMS Server » Server Administration » Deleting duplicate rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Deleting duplicate rows [message #371068]

Tue, 22 August 2000 03:53

Thavamani
Messages: 11
Registered: July 2000

Junior Member

Hi,
Can anyone hlp me in deleting duplicate rows without using rowid?

Report message to a moderator

Re: Deleting duplicate rows [message #371069 is a reply to message #371068]

Tue, 22 August 2000 10:25

Subrahmanyam Thodla
Messages: 6
Registered: February 2000

Junior Member

Here is an idea:

delete from cd where rowid in (select a.rowid from cd a where
a.rowid in (select b.rowid from cd b where a.id = b.id and
rownum < (select count(*) from cd d where d.id = b.id group by id )))

Report message to a moderator

Re: Deleting duplicate rows [message #371097 is a reply to message #371068]

Fri, 25 August 2000 07:08

geetha
Messages: 20
Registered: August 2000

Junior Member

The possible way to delete duplicate records without using rowid is
CREATE TABLE temp AS SELECT DISTINCT * FROM my_tab;
DROP TABLE my_tab;
RENAME temp TO my_tab;

There are many simple ways to delete duplicate rows using rowid. I would give it if u r interested.

Report message to a moderator