OraFAQ Forum: Server Administration » Delete Duplicate Rows

Home » RDBMS Server » Server Administration » Delete Duplicate Rows

Wed, 14 February 2001 22:07

Prashant patil
Messages: 6
Registered: October 2000

Junior Member

Is there any good method to delete duplicate rows from the table in single DELETE statement.

Fri, 16 February 2001 04:45

Mahesh Satam
Messages: 2
Registered: February 2001

Junior Member

Hi Prashant,
Hope this will help you..!

Delete from my_table where rowid not in
(select max(rowid) from my_table
group by my_column_name )
/

Fri, 16 February 2001 04:47

Mahesh Satam
Messages: 2
Registered: February 2001

Junior Member

Hi Prashant,
Hope this will help you..!

Delete from my_table where rowid not in
(select max(rowid) from my_table
group by my_column_name )
/

Wed, 23 May 2001 14:04

Raj
Messages: 411
Registered: November 1998

Senior Member

What is the role played by "max" before rowid. If I remove max and run the q it does't work. please explain.

thanks
raj

Previous Topic:	retrieve the image
Next Topic:	count function

Goto Forum:

]

Current Time: Mon Dec 23 12:58:34 CST 2024