Re: Capturing Duplicates

[suredata]

Thank you Bill, Ron, Dennis, Phil, and Albert for responding.  Apparently I did not make myself clear enough as to what I want.   I need to save all duplicate rows to a new table or file, not just knowing which rows in the original table have one or more duplicates.  In other words, if a row in the original table has 5 duplicates (or 6 identical rows in the table), I want to save these five duplicates as separate rows in a new table.   This new table would contain nothing but all duplicates in the original table.  Is there an easy way to achieve this?   I hope this is clearer.  Thanks again   Stan Loo