Message-Id: <10654.119744@fatcity.com> From: "Nikunj Gupta" Date: Thu, 19 Oct 2000 00:35:41 -0700 Subject: Re: urgent This is a multi-part message in MIME format. ------=_NextPart_000_00E1_01C03964.82DCDFC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable urgentHi Swapna, Use ROWID... (if you are not willing to use where clause with a long = list of values) Thanks Nikunj ----- Original Message -----=20 From: Swapna_P=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, October 18, 2000 01:06 PM Subject: urgent how to delete the duplicate records from a table............=20 except for one field all the rest of the fields are the same,so want = to eliminate one record=20 TIA=20 swapna=20 ------=_NextPart_000_00E1_01C03964.82DCDFC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable urgent
Hi Swapna,
 
Use ROWID... (if you are not willing to = use where=20 clause with a long list of values)
 
Thanks
 
Nikunj
 
----- Original Message -----
From:=20 Swapna_P=20
To: Multiple recipients of list = ORACLE-L=20
Sent: Wednesday, October 18, = 2000 01:06=20 PM
Subject: urgent

how to delete the duplicate = records from a=20 table............
except = for one=20 field all the rest of the fields are the same,so want to eliminate one = record

TIA
swapna