thiagowfx's avatar

¬ just serendipity 🍀 (not just serendipity)

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;