Re: Delete doubles
From: Sudip Roy <sudip.roy_at_in.bosch.com>
Date: 8 May 1999 03:46:08 GMT
Message-ID: <01be9904$c1c22e40$1a0394ad_at_mico6.ban.india.bosch.com>
Date: 8 May 1999 03:46:08 GMT
Message-ID: <01be9904$c1c22e40$1a0394ad_at_mico6.ban.india.bosch.com>
Delete from table T
where
(select col1 from T1 where rowid >
(select min(rowid) from T where T.col1=T1.col1))
here T1 and T is the same table from where you want to delete records and col1 is the primary key.
Hope it will work.
Actually above query is to delete duplicate record from a table
Bye
Sudip
Jérôme Texier <jtexier_at_ystel.fr> wrote in article
<7grgfg$3bq$1_at_jaydee.iway.fr>...
> Hello !
>
> I have load a table 2 times (there is no unique key constraint) and I
want
> to delete the second load without delete the first load.
> How can I do that ?
>
>
> Please help me !
>
> ---------------
> Jérôme
> jt_at_ystel.fr
> ---------------
>
>
>
Received on Sat May 08 1999 - 05:46:08 CEST