Re: urgent

From: Allan Nelson <anelson_at_houston.rr.com>
Date: Wed, 18 Oct 2000 20:50:03 -0500
Message-Id: <10653.119731@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>urgent</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-1">

<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>select ROWID from table where column =

values that=20
are in common =3D;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>delete from table where ROWID =3D the = one you want to=20
get rid of.</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20

  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
<A title=3DSwapna_P_at_satyam.com =

href=3D"mailto:Swapna_P_at_satyam.com">Swapna_P</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Wednesday, October 18, =
2000 3:06=20
  PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> urgent</DIV>
<DIV><BR></DIV>
<P><FONT face=3DArial color=3D#800080>how to delete the duplicate =
records from a=20
  table............</FONT> <BR><FONT face=3DArial color=3D#800080>except = for one=20
  field all the rest of the fields are the same,so want to eliminate one =

record</FONT> </P>
<P><FONT face=3DArial color=3D#800080>TIA</FONT> <BR><FONT =
face=3DArial=20
color=3D#800080>swapna</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Wed Oct 18 2000 - 20:50:03 CDT