Re: Delete Duplicate Records !!!!

Hi,

you can use rowid to differenciate two otherwise identical rows. the delete statement is like this:

• no warranties on that, this is just to show the idea, not testet !!!

delete from mytab where rowid in
 (select rowid from mytab a, mytab b
   where a.unq_col = b.unq_col
     and a.rowid > b.rowid)

Karsten

In article <7u5s2o$116a$1_at_newssvr04-int.news.prodigy.com>,   "Steve" <schen_at_prodigy.net> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 15 1999 - 05:21:06 CDT