LeetCode

    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;
原文地址:https://www.cnblogs.com/wxisme/p/4436615.html