#182 Duplicate Emails

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

MS SQL Server

SELECT Email
FROM Person
GROUP BY Email
HAVING COUNT(Email) > 1;