'What is the difference b/w both the MySql Query

This is working

DELETE FROM Person WHERE Id NOT IN 
(SELECT * FROM(
    SELECT MIN(Id) FROM Person GROUP BY Email) as p);

this is not working

DELETE FROM Person WHERE Id NOT IN 
(SELECT MIN(Id) FROM Person GROUP BY Email));

Can anyone explain why...?

mysql

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source