方法1:采用分组的方式:
select
email as Email
from
Person
group by
email
having
count(id) > 1
-- 采用分组将email相同的分为一组,再通过count选出出大于1的。
方法2: 采用distinct加内连接的方式:
* Write your T-SQL query statement below */
select
distinct p1.email as Email
from
Person as p1
inner join
Person AS p2
on
p1.email = p2.email
where
p1.id <> p2.id and p1.email = p2.email
-- 1、先使用内连接连接,2、再将条件设为id不同而email相同,3、最后再排除相同项