Question is, what are you wanting to do with this duplicate info? Are there
other columns that are not duplicates? Maybe there is a better way to
accomplish your goal.
-- Dennis McGrath
mailto:[EMAIL PROTECTED]
-- Productivity Tools for R:Base Programmers
http://www.enteract.com/~mcgrath/dennis
-- Full time consultant with:
SQL Resources Group
Steve Hartmann
Oak Park, IL
mailto:[EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of suredata
Sent: Wednesday, August 08, 2001 7:32 AM
To: [EMAIL PROTECTED]
Subject: Re: Capturing Duplicates
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
