如何将位字段中的正确/错误计数分为两个单独的列 [英] How to get the true/false count from a bit field into two separate columns

问题描述

我需要创建一个查询，将一个位字段的True(1)和False(0)的数量加到两个独立的列中.

I need to create a query that will sum the number of True(1) and False(0) into two separate columns from one bit field.

我要加入3个表，并且需要像这样:

I'm joining 3 tables and need it to be something like:

属性|班级|通过|失败

Attribute | Class | Pass | Fail

我将按属性和类分组.

推荐答案

类似以下内容:

SUM(CASE WHEN ColumnName = 1 THEN 1 ELSE 0 END) AS Pass, 
SUM(CASE WHEN ColumnName = 0 THEN 1 ELSE 0 END) AS Fail

这篇关于如何将位字段中的正确/错误计数分为两个单独的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！