Removing duplicate fields (emails as example) solution

for i in select Table_Name.Email_field do
while cnt(select Table_Name where Email_field = text(i))!=1 do
delete last(select Table_Name where Email_field = text(i))
end
end

Enjoy!