美文网首页
182. Duplicate Emails

182. Duplicate Emails

作者: 无敌的肉包 | 来源:发表于2018-06-07 11:53 被阅读0次

    Write a SQL query to find all duplicate emails in a table named Person.

    +----+---------+
    | Id | Email   |
    +----+---------+
    | 1  | a@b.com |
    | 2  | c@d.com |
    | 3  | a@b.com |
    +----+---------+
    

    For example, your query should return the following for the above table:

    +---------+
    | Email   |
    +---------+
    | a@b.com |
    +---------+
    

    SELECT Email   
    FROM Person
    GROUP BY Email   
    Having count(Email)>1
    

    相关文章

      网友评论

          本文标题:182. Duplicate Emails

          本文链接:https://www.haomeiwen.com/subject/xgtgsftx.html