Re: Delete Duplicate rows from a table
From: Joseph Ovadia <ovadia_at_att.com>
Date: Thu, 14 Jun 2001 07:36:48 -0400
Message-ID: <3B28A1D0.B423BE1F_at_att.com>
Date: Thu, 14 Jun 2001 07:36:48 -0400
Message-ID: <3B28A1D0.B423BE1F_at_att.com>
try uniq. man uniq.
Joseph Kohler wrote:
> 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 Thu Jun 14 2001 - 13:36:48 CEST