Message-Id: <10653.119731@fatcity.com> From: "Allan Nelson" Date: Wed, 18 Oct 2000 20:50:03 -0500 Subject: Re: urgent This is a multi-part message in MIME format. ------=_NextPart_000_0127_01C03944.FD345AC0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable urgentselect ROWID from table where column values that are in common = =3D; delete from table where ROWID =3D the one you want to get rid of. ----- Original Message -----=20 From: Swapna_P=20 To: Multiple recipients of list ORACLE-L=20 Sent: Wednesday, October 18, 2000 3: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_0127_01C03944.FD345AC0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable urgent
select ROWID from table where column = values that=20 are in common =3D;
delete from table where ROWID =3D the = one you want to=20 get rid of.
----- Original Message -----
From:=20 Swapna_P=20
To: Multiple recipients of list = ORACLE-L=20
Sent: Wednesday, October 18, = 2000 3: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