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;
β’ 26 words β’ 1 min β’ updated
LeetCode #182: Duplicate Emails:
SELECT EMAIL FROM (
SELECT EMAIL, COUNT(EMAIL) AS NUM FROM PERSON GROUP BY EMAIL
) AS _T WHERE NUM > 1;