Re: Help with duplicate records in SQL

FROM ORACLE TECHNICAL BULLETIN MARCH 1992

• Only Recently been made available

"The following SQL script will remove duplicate rows from the table specified by the parameter &1, where the duplicate rows are defined by identical values for the column-list defined by the parameter &2:

DELETE FROM &1
WHERE
 ROWID NOT IN (
    SELECT MAX(ROWID) FROM &1
    GROUP BY &2
    )
/ "

Problem solved now?

Lez

-- 
Lez Oxley, Administration, University of Sussex, Brighton, BN1 9RH, UK
Tel: +44 273 606755 x3808 Fax: +44 273 678335 JANET: lezo_at_uk.ac.sussex.syma
ARPA: lezo%syma.sussex.ac.uk_at_nsfnet-relay.ac.uk
BITNET: lezo_at_syma.sussex.ac.uk      UUCP: lezo_at_syma.uucp