hi,
i have a table with mora than 12000 registries and aprox. 1000 duplicated, how can i delete them with a sql command?
thanksss

http://support.microsoft.com/default...b;en-us;139444

I know it says it works for SQL Server, but ignore that. If you use SQL to talk to your db, then that solution applies to you, too.

Try this work out-

select unique records and store them in some temporary table.
Then drop your table containing duplications.
again create a table of original name from temporary table.

sql> create table TMP select distinct * from YOUR_TABLE;
SQL>drop table TMP; //or truncate
sql> create table YOUR_TABLE select * from TMP;


Best Regards
Milind