Re: Q: Duplicate records

In article <1993Jan23.124513.26942_at_kaija.spb.su>, adn_at_kaija.spb.su (ADN communication group) writes:
|> Does anyone know how to remove duplicated records from existing
|> Oracle table? Records may not be duplicated in all fields.

DELETE FROM &TABLE
WHERE ROWID NOT IN
   (SELECT MAX(ROWID) FROM &TABLE
    GROUP BY &DUPLICATE_COLUMNS
   )
/

|> --
|> Nick Maximov
|> St. Petersburg, Russia
 

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas_at_aberdeen.chevron.com       Phone: +44 224 242637