Find and remove duplicates in table - keeps only distinct values (without a temp table)

mysql-remove-duplicates

SELECT people_user.*
FROM people_user
LEFT OUTER JOIN (
   SELECT MIN(user_id) as MinId, email 
   FROM people_user
   GROUP BY email
) as KeepRows ON
   people_user.user_id = KeepRows.MinId
WHERE
   KeepRows.MinId IS NULL;


DELETE people_user
FROM people_user
LEFT OUTER JOIN (
   SELECT MIN(user_id) as MinId, email 
   FROM people_user
   GROUP BY email
) as KeepRows ON
   people_user.user_id = KeepRows.MinId
WHERE
   KeepRows.MinId IS NULL;