One more time, Assume fld1,fld2,fld3 constitute a unique record

SELECT fld1,fld2,fld3
FROM <table>
GROUP BY fld1,fld2,fld3
HAVING COUNT(*) > 1;

Other ways but this will work

Rick




"wei"
<[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
mail.com> cc:
Subject: Find duplicate rows
02/28/2002
01:20 PM






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