How to delete duplicate records with condition

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

Re: How to delete duplicate records with condition

recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: How to delete duplicate records

Delete duplicate records with condition

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