Let you have some filed key-k_id, which by choise get duplicate values
select count(*) as cntt ,k_id group by k_id into cursor tmp
delete from tblname where k_id in ( select k_id from tmp where cntt>1)
It really can be one clause using having count()>1
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.