Re: removing duplicate records

On Thu, 05 Aug 2004 20:57:28 +0200, Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:
> Tom had an elegant solution for this in last OraMag using analytics.

too many brackets for me.

delete from emp where rowid in
(select rowid from emp
minus
select min(rowid) from emp
group by id);

fast too.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------