LeetCode #182: Duplicate Emails
• 26 words • 1 min • updated
LeetCode #182: Duplicate Emails:
sql
SELECT EMAIL FROM (
SELECT EMAIL, COUNT(EMAIL) AS NUM FROM PERSON GROUP BY EMAIL
) AS _T WHERE NUM > 1;∎
Connections
Shared tags