[Solved] Sql Query condition based on column can holded bit

by


Is this what you are looking for?

select ProdID, 
       min(Qualified),
       case when min(Qualified) <> max(Qualified) 
            then 'YES'
            else 'NO'
       end as Has_different_results
from VarAnn_Data.dbo.tblOwnership
group by ProdID

solved Sql Query condition based on column can holded bit