Re: DELETING IDENTICAL ROWS IN A TABLE

Try this :

delete from table_name
where rowid NOT in (

     select min(rowid) from table_name group by 
         primary_key);

Yao

Shiva K Mantri (CS) <smantri_at_site.gmu.edu> wrote in article <5mlidr$2ei_at_portal.gmu.edu>...
> Hi everybody,
>
> How can I delete rows with identical primary key values using SQL
 commands
> rather than PL/SQL.
>
> ----SHIVA
>
>
Received on Sat May 31 1997 - 00:00:00 CEST