1
2
3
4
5
6
7
8
9
10
11
12
| -- @Title: 查找重复的电子邮箱 (Duplicate Emails)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 14:35:24
-- @Runtime: 243 ms
-- @Memory: 0 B
# Write your MySQL query statement below
select Email
from Person
group by Email
having
count(distinct Id) >1
|