Re: Remove duplicates

From: Shen, Art [BRAM:K500:EXCH] <arts_at_americasm01.nt.com>
Date: Tue, 13 Mar 2001 17:41:30 -0500
Message-ID: <98m7hj$qdu$1@bcrkh13.ca.nortel.com>

Please try this;

        delete from TABLE_NAME a
        where a.rowid != (select max(row_id) from TABLE_NAME b
                                    where b.col_name = a.col_name)

"xiaomh" <xiaomh_at_hotmail.com> wrote in message news:98j40g$c47$1_at_news.gov.on.ca...
> I want to import 10000 entries to my database. There are some duplicates
in
> them.
>
> What's the best way to remove them(duplicates)?
>
> Thanks in advance!
>
>
Received on Tue Mar 13 2001 - 16:41:30 CST