Ave ! How about something like:
delete from varukorgtmp where varutyp = 3 and EAN = (select EAN from varukorgtmp a where rowid != (select min(rowid) from varukorgtmp b where a.EAN = b.EAN)); Should work, but not tested :) Br.Jorma ----------------------------------------------------------------- Name: Jorma Vuorio Phone: +358-9-7180 67759 Company: Nokia Business Infrastucture Fax: +358-9-7180 67465 Address: P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND Internet: [EMAIL PROTECTED] Mobile: +358-50-486 8043 ----------------------------------------------------------------- -----Original Message----- Sent: 08 January, 2003 10:24 To: Multiple recipients of list 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
