search

yokostan / Leetcode-Solutions

Doing exercise on Leetcode. Carry on!
0 stars 3 forks source link

Leetcode #182. Duplicate Emails #213

Open yokostan opened 5 years ago

yokostan commented 5 years ago 
# Write your MySQL query statement below
SELECT DISTINCT Email
FROM Person
GROUP BY Email
HAVING COUNT(Id) > 1