如何在SQL中过滤重复记录 [英] How to filter duplicate records in sql

问题描述

select vCompanyName,vemailid
 from tblmembers 

在这里，我不想重复vCompanyName
重复但不起作用
请帮助..

here i dont want duplicate vCompanyName
itried with distinct but not working
pls help..

推荐答案

您可以尝试以下方法:

You can try this:

SELECT vCompanyName, MIN(vemailid)
FROM results
GROUP BY vCompanyName

试试这个

Try this

Select tmp.vCompanyName , tblmembers.vemailid
from
(
Select vCompanyName  from tblmembers
group by vCompanyName
having count(vCompanyName) =1
) As tmp
inner join tblmembers on tblmembers.vCompanyName =tmp.vCompanyName

在这里，您在整个select查询中使用的是不同的，表示它将检查公司名称和emailid的组合中是否存在重复记录
这就是为什么您使用不同的emailid获得相同的公司名称的原因

如果您想要唯一的公司名称，请使用此

Here you are using distinct on entire select query means it will check whether there are any duplicate records in combination of companyname and emailid
thats why you are getting same companyname with different emailid''s

if you want unique company names then use this

select distinct vCompanyName from tblmembers

希望这对您有帮助

hope this helps you

这篇关于如何在SQL中过滤重复记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！