inblog logo
|
stupefyee
    SQL문제풀기

    [SQL 문제 풀이] Duplicate Emails (중복 이메일)

    Stupefyee's avatar
    Stupefyee
    May 21, 2025
    [SQL 문제 풀이] Duplicate Emails (중복 이메일)
    Contents
    내가 작성한 쿼리
    Duplicate Emails - LeetCode
    Can you solve this real interview question? Duplicate Emails - Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-------------+---------+ id is the primary key (column with unique values) for this table. Each row of this table contains an email. The emails will not contain uppercase letters.   Write a solution to report all the duplicate emails. Note that it's guaranteed that the email field is not NULL. Return the result table in any order. The result format is in the following example.   Example 1: Input: Person table: +----+---------+ | id | email | +----+---------+ | 1 | a@b.com | | 2 | c@d.com | | 3 | a@b.com | +----+---------+ Output: +---------+ | Email | +---------+ | a@b.com | +---------+ Explanation: a@b.com is repeated two times.
    Duplicate Emails - LeetCode
    https://leetcode.com/problems/duplicate-emails/description/
    Duplicate Emails - LeetCode
    notion image
    모든 중복 이메일을 보고할 수 있는 솔루션을 작성합니다. 이메일 필드가 NULL이 아님이 보장됩니다. 결과 테이블을 순서에 상관없이 반환하세요.
     

    내가 작성한 쿼리

    MySQL, Oracle

    SELECT email FROM Person GROUP BY email HAVING COUNT(*) > 1;
    Share article
    Contents
    내가 작성한 쿼리

    stupefyee

    RSS·Powered by Inblog