LeeCode/릿코드-Duplicate Emails-MySQL

문제

풀이

• write ans sql query to report all the duplicate emails.
• return the result table in any order.
• the query result format is in the following example.

코드

--leetcode, Duplicate Emails, mysql
SELECT Email
FROM Person
GROUP BY Email
HAVING COUNT(Email) > 1

결과

출처 && 깃허브

leetcode
github