image_2022-01-11_15-39-20.png
19.5 KB
#N182. Duplicate Emails
problem link
#solution
problem link
#solution
select email from
(select email, count(email) as num from person group by email) as temp
where num>1;