Re: Deleting duplicates
From: sanat <joshis_at_detroitedison.com>
Date: 1996/06/20
Message-ID: <4qbvsv$8ik_at_news.deco.com>#1/1
Date: 1996/06/20
Message-ID: <4qbvsv$8ik_at_news.deco.com>#1/1
Here's a very fast way of deleting duplicates:
delete from CUSTOMERS A where rowid < any
(select rowid from CUSTOMERS B where
B.CUST_ID = A.CUST_ID)
Sanat
Received on Thu Jun 20 1996 - 00:00:00 CEST