RE: Duplicate rows

From: Alexander Ordonez <aordonez_at_ccss.sa.cr>
Date: Wed, 06 Feb 2002 10:39:55 -0800
Message-ID: <F001.0040771E.20020206082834@fatcity.com>

thanks!!!

@lex

---

  Lic. Alexander Ordóñez Arroyo

  Caja Costarricense del Seguro Social                             
  Soporte Técnico - División de Informática                     
  Telefono: 295-2004, San José, Costa Rica                    
  Aordonez_at_ccss.sa.cr        Icq# 30173325

------------------------------------------------------------

The true is out there in WWW

> -----Mensaje original-----
> De: Rick_Cale_at_teamhealth.com [SMTP:Rick_Cale_at_teamhealth.com]
> Enviado el: Miércoles 6 de Febrero de 2002 10:26 AM
> Para: ORACLE-L_at_fatcity.com; aordonez_at_ccss.sa.cr
> Asunto: Re: Duplicate rows
>
>
> DELETE FROM <table> a
> WHERE a.rowid > (SELECT MIN(b.rowid)
> FROM table b
> WHERE b.key_field1 = a.keyfield1
> AND b.key_field2 = a.keyfield2
> AND b.key_fieldN = a.keyfieldN);
>
> Be certain to include all fields in WHERE clause that make up a unique
> record.
>
> Rick
>
>
>
>
>
> Alexander
>
> Ordonez To: Multiple recipients of
> list ORACLE-L <ORACLE-L_at_fatcity.com>
> <aordonez_at_ccs cc:
>
> s.sa.cr> Subject: Duplicate rows
>
> Sent by:
>
> root_at_fatcity.
>
> com
>
>
>
>
>
> 02/06/2002
>
> 10:33 AM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> Hi gurus,
> I need detect and delete duplicate rows in any table, somebody helpme
> thanks!!!
>
> @lex
> ------------------------------------------------------------
> Lic. Alexander Ordóñez Arroyo
> Caja Costarricense del Seguro Social
> Soporte Técnico - División de Informática
> Telefono: 295-2004, San José, Costa Rica
> Aordonez_at_ccss.sa.cr Icq# 30173325
>
> ------------------------------------------------------------
> The true is out there in WWW
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Alexander Ordonez
> INET: aordonez_at_ccss.sa.cr
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexander Ordonez
  INET: aordonez_at_ccss.sa.cr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Feb 06 2002 - 12:39:55 CST