stan,
Create a view, and project a temporary table (or a permanent table)
from the view, or insert into a new table from the view:
CREATE VIEW FindDups +
(Col1, Col2, Col3, Occurs) +
AS +
SELECT col1, col2, col3, count (*) +
from tablename +
group by col1, col2, col3 +
having count (*) > 1
SEL * FROM FindDups
On Tue, 7 Aug 2001 17:36:12 -0400, suredata wrote:
>I have a three-column table (say TestTable with columns Col1, Col2,
Col3). Duplicates are present. I want to save all duplicates in a table
or file. Is there an easy way to achieve this?
>
>
>
>TIA
>
>
>
>Stan Loo
>
>
