Re: Delete Duplicate rows from a table
From: Joseph Kohler <joe_kohler_at_yahoo.com>
Date: Wed, 13 Jun 2001 13:55:04 -0400
Message-ID: <3B27A8F8.386CA05B_at_yahoo.com>
Date: Wed, 13 Jun 2001 13:55:04 -0400
Message-ID: <3B27A8F8.386CA05B_at_yahoo.com>
SATYA PAL wrote:
>
> Hi There,
>
> I have a frequent requirement to delete the duplicate rows from a
> table. I know one method using the RowID to delete the duplicate from
> the table.
>
> Is there any best mechanism to delete duplicate rows from the table.
>
> Thanks in advance.
>
> Regards
> Satya
Try exporting the table to a flat file and look at a unix utility to delete duplicates (I don't know the util off hand).
-- Joe. -- Nothing is foolproof to a sufficiently talented fool!Received on Wed Jun 13 2001 - 19:55:04 CEST