Code delete from Person where Id not in (select * from (select min(Id) from Person group by Email) t);