Re: Delete Duplicate Records !!!!

From: Arati Vijay <vijayj_at_singnet.com.sg>
Date: Tue, 19 Oct 1999 00:25:59 +0800
Message-ID: <7ufhtm$6um$1@mawar.singnet.com.sg>

Try this

CREATE TABLE new_table AS (
SELECT DISTINCT * FROM old_table);

DROP TABLE old_table;

Regards,
VJ

Steve <schen_at_prodigy.net> wrote in message news:7u5s2o$116a$1_at_newssvr04-int.news.prodigy.com...
> Hi, All:
>
> Can anybody tell me how to find all duplicate records and delete them in
one
> coding? We have thousand of duplicate records needed to be deleted in
> one table (please don't ask why -- unquiue key issue).
>
> Apprecreciated.
>
> Steve
>
>
>
Received on Mon Oct 18 1999 - 11:25:59 CDT