bit 型数据如何做group by

Question

select aa_no,aa_name, sum(aa_qty),convert(int,aa_bit)
from tab1
group by aa_no,aa_name,convert(int,aa_bit)

Answer 1

select aa_no,aa_name, sum(aa_qty),convert(varchar(3000),函数(aa_bit)) as aa_bit
from tab1
group by aa_no,aa_name

Answer 2

--我没有测试你看看
select a.aa_no,a.aa_name, sum(a.aa_qty) as aa_qty ,
(select b.aa_bit from tab1 b where a.aa_no=b.aa_no and a.aa_name=b.aa_name )as aa_bit
from tab1 a
group by a.aa_no,a.aa_name

Answer 3

convert(int,aa_bit)  转移下就ok了