Message-Id: <10654.119812@fatcity.com> From: "paul" Date: Thu, 19 Oct 2000 01:35:13 -0500 Subject: Re: urgent This is a multi-part message in MIME format. ------=_NextPart_000_0011_01C0396C.D3982A70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable HI SWAPNA, This is may help you. give try on this.=20 delete from TABLENAME where rowId not in (select min(rowid) from = TABLENAME group by COLUMN_NAME) paul.j chennai -----Original Message----- From: Swapna_P To: Multiple recipients of list ORACLE-L Date: Wednesday, October 18, 2000 2:19 PM Subject: urgent =20 =20 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_0011_01C0396C.D3982A70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable urgent
HI  SWAPNA,
 This is may help you. give try = on=20 this. 
 delete from  = TABLENAME  where=20 rowId not in (select min(rowid) from TABLENAME group by=20 COLUMN_NAME)

paul.j
chennai
-----Original = Message-----
From:=20 Swapna_P <Swapna_P@satyam.com>
To:= =20 Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
D= ate:=20 Wednesday, October 18, 2000 2:19 PM
Subject:=20 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=20 record

TIA
swapna