From aordonez@ccss.sa.cr Wed, 06 Feb 2002 10:39:55 -0800
From: Alexander Ordonez <aordonez@ccss.sa.cr>
Date: Wed, 06 Feb 2002 10:39:55 -0800
Subject: RE: Duplicate rows
Message-ID: <F001.0040771E.20020206082834@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain


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@ccss.sa.cr        Icq# 30173325

------------------------------------------------------------
The true is out there in WWW

> -----Mensaje original-----
> De:   Rick_Cale@teamhealth.com [SMTP:Rick_Cale@teamhealth.com]
> Enviado el:   Miércoles 6 de Febrero de 2002 10:26 AM
> Para: ORACLE-L@fatcity.com; aordonez@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@fatcity.com>       
>                     <aordonez@ccs        cc:
> 
>                     s.sa.cr>             Subject:     Duplicate rows
> 
>                     Sent by:
> 
>                     root@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@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@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@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@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@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).