在同一个表中具有两列的 SQL Server 不同查询

Question

我的表是:

tblProduct

male| female| Brand_ID 

和

tblBrands

Brand_ID| Brand_Name 

我的查询在这里:

Select distinct   
    a.Male, a.Female, b.Brand_Name 
from 
    tblProduct as a 
inner join
    tblBrands as b on b.Brand_ID = a.Brand_ID

这个查询返回这个输出:

Male    Female  Brand_Name
----------------------------------
 1       0        ABC
 0       1        ABC
 1       0        ABC
 1       0        PQR
 1       0        PQR
 0       1        PQR
 0       1        XYZ
 0       1        XYZ

但我想要下面显示的输出 - 我应该怎么做才能得到这个？

Male    Female  Brand_Name
 ----------------------------------
 1       1        ABC
 1       1        PQR
 0       1        XYZ

检查品牌 XYZ 是男性还是女性，如果男性位为真，女性位为真，则显示 XYZ 1 1 或根据该显示 XYZ 1 0 或 XYZ 0 1

Answer 1

一个简单的 GROUP BY 子句将解决您的问题

Select   
  Max(cast(a.Male as int)) as Male  , 
  Max(cast(a.Female as int)) as Female,
  b.Brand_Name 
from tblProduct as a inner join
tblBrands as b on b.Brand_ID = a.Brand_ID
group by b.Brand_Name