Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Duplicate records

Re: Duplicate records

From: Happy <allan_at_livvy80.freeserve.co.uk>
Date: Thu, 25 Jan 2001 23:26:52 -0000
Message-ID: <94qcrp$c85$1@news8.svr.pol.co.uk> 






delete from table_name


where rowid in


    (select min(rowid) from table_name


    group by col1, col2, coln


    having count(0) > 1)



Cheers


Allan



"Screamer" <mflopes_at_bigfoot.com> wrote in message
news:94q1l9$ejm$1_at_venus.telepac.pt...


> Can someone post a piece of SQL that deletes duplicate records in a table,

> please ?

>

>

Received on Thu Jan 25 2001 - 17:26:52 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US