LeetCode - Duplicate Emails

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

     找出表中重复的Email。

    

# Write your MySQL query statement below
select Email 
from Person group by Email having count(*)>1;

 

posted @ 2015-04-18 09:02  Pickle  阅读(162)  评论(0编辑  收藏  举报