请问如何实现sum关于bit位的统计呢？在线等

Question

select merchant_id,branch_id,pos_id,internal_id,sum(cast(is_fault as tinyint))
from v_error
where balance_time between '1999-12-12' and '2003-12-12'
group by balance_time,merchant_id,branch_id,pos_id,internal_id

Answer 1

--or:
select merchant_id,branch_id,pos_id,internal_id,count(*)
from v_error
where balance_time between '1999-12-12' and '2003-12-12' and is_fault=1
group by balance_time,merchant_id,branch_id,pos_id,internal_id