Re: Duplicated records

> How can I delete the duplicated records with "DELETE FROM TABLE WHERE..."
> clause??
> The problem is becouse I have imported data from Dbase (dbf) file, and  
> this
> function have not built the Constraint (unique, primary key, ...), and  
> this
> function is usually executed.
If you have no primary key how can you reference a record in order to  
delete it ?I'd say use a temporary table...If you have complete row dupes (ie. the entire row is duplicated) useSELECT
*FROM table GROUP BY *(or select distinct)
 
If only the primary key is duplicated but other fields change, then you  
have to decide which one you wanna keep !