Mike,

thanks for reply, but I did'nt quite get what you mean. The table have unique index key but the column I try to find don't have unique key. Could you please kind give me example?
thanks again,

WZ
----- Original Message -----
From: Mike Ault
To: 'wei' ; 'LazyDBA.com Discussion'
Sent: Thursday, February 28, 2002 7:23 AM
Subject: RE: Find duplicate rows


Do a min/max against an embedded recursive query against the same table using rowid.

Mike
-----Original Message-----
From: wei [mailto:[Email Address Removed] Sent: Thursday, February 28, 2002 1:21 PM
To: LazyDBA.com Discussion
Subject: Find duplicate rows


Hi all,

I am sure this question has been asked many times but I don't seems to find it from archive, here goes again. How do find all the duplicate rows in a table?
thanks,

WZ
Oracle LazyDBA home page