182_Duplicate_emails

// https://leetcode.com/problems/duplicate-emails/


# select distinct a.Email as 'Email' from Person as a, Person as b where a.Email = b.Email AND a.Id != b.Id;


# select Email from (select Email, count(Email) as num from Person group by Email) as temp where num > 1;



select Email from Person group by Email having count(Email)>1;