我需要运行一个 select 语句,返回列值不不同的所有行(例如 EmailAddress)。
例如,如果表格如下所示:
CustomerName EmailAddress
Aaron [email protected] /cdn-cgi/l/email-protection
Christy [email protected] /cdn-cgi/l/email-protection
Jason [email protected] /cdn-cgi/l/email-protection
Eric [email protected] /cdn-cgi/l/email-protection
John [email protected] /cdn-cgi/l/email-protection
我需要返回查询:
Aaron [email protected] /cdn-cgi/l/email-protection
Christy [email protected] /cdn-cgi/l/email-protection
John [email protected] /cdn-cgi/l/email-protection
我读了很多帖子并尝试了不同的查询但无济于事。我认为应该有效的查询如下。有人可以提出替代方案或告诉我我的查询可能有什么问题吗?
select EmailAddress, CustomerName from Customers
group by EmailAddress, CustomerName
having COUNT(distinct(EmailAddress)) > 1
这比EXISTS
way:
SELECT [EmailAddress], [CustomerName] FROM [Customers] WHERE [EmailAddress] IN
(SELECT [EmailAddress] FROM [Customers] GROUP BY [EmailAddress] HAVING COUNT(*) > 1)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)