RE: Find duplicate rows

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