Re: urgent

From: paul <pjohnpeter_at_qssnet.com>
Date: Thu, 19 Oct 2000 01:35:13 -0500
Message-Id: <10654.119812@fatcity.com>

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 <Swapna_P_at_satyam.com>     To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>     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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3Dtext/html;charset=3Diso-8859-1=20
http-equiv=3DContent-Type><TITLE>urgent</TITLE><!DOCTYPE HTML PUBLIC = "-//W3C//DTD HTML 3.2//EN">
<META content=3D'"MSHTML 4.72.3110.7"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#000000 size=3D2>HI  SWAPNA,</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2> This is may help you. give try =
on=20
this. </FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2> delete from  =
TABLENAME  where=20
rowId not in (select min(rowid) from TABLENAME group by=20 COLUMN_NAME)</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2><BR>paul.j</FONT></DIV>
<DIV><FONT color=3D#000000 size=3D2></FONT><FONT =
size=3D2>chennai</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 solid 2px; MARGIN-LEFT: 5px; PADDING-LEFT: = 5px">

<DIV><FONT face=3DArial size=3D2><B>-----Original = Message-----</B><BR><B>From:=20

</B>Swapna_P <<A=20
=
href=3D"mailto:Swapna_P_at_satyam.com">Swapna_P_at_satyam.com</A>><BR><B>To:= =20

</B>Multiple recipients of list ORACLE-L <<A=20

    =
href=3D"mailto:ORACLE-L_at_fatcity.com">ORACLE-L_at_fatcity.com</A>&gt;<BR><B>D=
ate:=20
    </B>Wednesday, October 18, 2000 2:19 PM<BR><B>Subject:=20

</B>urgent<BR><BR></DIV></FONT>
<P><FONT color=3D#800080 face=3DArial>how to delete the duplicate = records from a=20

table............</FONT> <BR><FONT color=3D#800080 = face=3DArial>except for one=20

field all the rest of the fields are the same,so want to eliminate = one=20

record</FONT> </P>
<P><FONT color=3D#800080 face=3DArial>TIA</FONT> <BR><FONT = color=3D#800080=20

face=3DArial>swapna</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Thu Oct 19 2000 - 01:35:13 CDT