Re: How to delete duplicate records with condition

Hi,

      following metalink documents may help you.

Note:65080.1 Using SQL To Delete Duplicate Rows In A Table

PR:1015631.6 HOW TO SELECT DUPLICATE ROWS WITHOUT USING ROWID PR:1004425.6 HOW TO FIND OR DELETE DUPLICATE ROWS IN TABLE Murat

                                                                                                                                       
                      roland.skoldblom@                                                                                                
                      ica.se                   To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                   
                      Sent by:                 cc:                                                                                     
                      root_at_fatcity.com         Subject:  How to delete duplicate records with condition                                
                                                                                                                                       
                                                                                                                                       
                      01/07/2003 03:28                                                                                                 
                      PM                                                                                                               
                      Please respond to                                                                                                
                      ORACLE-L                                                                                                         
                                                                                                                                       
                                                                                                                                       

Hallo,

I have this sql,

SELECT * FROM varukorgtmp
where varukorgid= 120 That makes the result of this testfile.xls

(See attached file: start.xls)

There are two values in EAN-field, which are the same 23324614 in row 2 and 3

Now I want in an sql script to check out which are the duplicates of EAN in that table. Then then the script will check which is VARUTYP = 3, then delete the record(s) which have VARUTYP =3.

So the result should be like this, with only two rows left in this case).

(See attached file: result.xls)

I would really appreciate if anyone could help me with this sql I have tried several sql, but with no luck.

Thanks in advance

Roland

(See attached file: start.xls)(See attached file: result.xls)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MURAT BALKAS
  INET: murat.balkas_at_o2.net.tr

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).



application/msexcel attachment: start.xls



application/msexcel attachment: result.xls