Sql查询选择distict值 [英] Sql query to select distict values

问题描述

查询

query

select  C.CompanyName ,C.CompanyID,R.URLPart,C.Photo,T.ReportID 
   from  dbo.KALKINE_Company C
 inner join
  dbo.KALKINE_ReportsCompanyTag T
  on C.CompanyID = T.CompanyID 
    inner join dbo.KALKINE_Reports R on R.CompanyID = T.CompanyID
      where T.ReportID =  855

我尝试过：



i厌倦了获得CompanyName，CompanyID，URLPart

What I have tried:

i tired to get the distinct values of CompanyName ,CompanyID,URLPart

推荐答案

的明确值你需要使用DISTINCT关键字。

To select distinct you need to use the DISTINCT keyword.

SELECT DISTINCT companyName, CompanyId, URLPart
FROM ...

这将合并3个值。

This will get distinct of the 3 values combined.

SELECT DISTINCT C.CompanyName ,C.CompanyID,R.URLPart,C.Photo,T.ReportID
FROM dbo.KALKINE_Company C
WHERE T.ReportID =  855

这篇关于Sql查询选择distict值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！