RE: urgent

From: Norwood Bradly A <Bradley.A.Norwood_at_M1.IRSCOUNSEL.TREAS.GOV>
Date: Wed, 18 Oct 2000 17:01:08 -0400
Message-Id: <10653.119719@fatcity.com>

A few useful scripts for doing this is available in the Tip Archives at www.oramag.com. <http://www.oramag.com> I noticed a couple of scripts for ridding the table of duplicates in the 1997 tips area.

-----Original Message-----
From: Veera Prasad [mailto:vprasad_at_olf.com] Sent: Wednesday, October 18, 2000 4:21 PM To: Multiple recipients of list ORACLE-L Subject: Re: urgent

Couple of methods to eliminate duplicate values , here I go with First Method:
delete <table_name> a where rowid > (select min(rowid) from <table_name> b where a.col_name = b.col_name;

Second Method:
delete <table_name> a where exists (select 'Dupes' from <table_name> b where a.col_name = b.col_name and b.rowid > a.rowid);

Veera
Swapna_P wrote:

how to delete the duplicate records from a table............ except for one field all the rest of the fields are the same,so want to eliminate one record Received on Wed Oct 18 2000 - 16:01:08 CDT