Re: Eliminating Dup Records

From: <ps_at_netvigator.com>
Date: 1996/07/19
Message-ID: <4so508$skc_at_imsp003.netvigator.com>#1/1

I think it could be more simple,

delete from table1 T1
where T1.rowid > ( select min(T2.rowid) from table1 T2 where T1.P1 = T2.P1 and T1.P2 = T2.P2 );

P.S.

~~~~~ ~~~~~~~~~~~ ~~~~~~~~~~~~ ~~~~~ ~~~~~~~~~~~~~~~~~~ ~~~~~~ ~~~~~~~~~

 ~~ Life is always Hard ~~~~~~~~~ ~~~~~~ ~~~~~ ¥Í¬¡±q¤£»´ÃP ~~~~~~ ~~~~~~~

  ~~~ Love is never Smooth ~~ ~~~~~~~~~~~~~ ~~~~ ·R±¡§ó«D©Z³~ ~~~~~~~~~~~~~~
   ~~~~ Always Love hard and never Life smooth ~~~ °ß¦³¼ö¤Á¦a·R,Åý¥Í©R§óºëªö ~
    ~~~~~~~~ ~~~~~ ~~~ ~~~~~~~~~~~~~~~ ~~~~ ~~~~~~~~~~~~ ~~~~~~~~~~~~~~ 
~~~~~~~~
     ~~~~ ~~~~~~~~~~~~~~~~~~~~~ ~~ ~~~~~~~~~~~ ~~~~~~~~ ~~~~~~~ ~~~ P.S. ~~~~~
                                                      ~~~~ ~~~~~~~~~~ ~~~~~~

Received on Fri Jul 19 1996 - 00:00:00 CEST