汇总查询问题

[bigemc2]

原表如下：
create table #test
(
con nvarchar(20),
code nvarchar(20),
quan decimal
)
insert into #test (con,code,quan) values ('111','A','10')
insert into #test (con,code,quan) values ('111','A','5')
insert into #test (con,code,quan) values ('111','B','8')
insert into #test (con,code,quan) values ('112','A','8')
insert into #test (con,code,quan) values ('112','A','2')


我想要统计code字段重复出现的次数，但是con字段相同的code只算一次。
结果如下：
code 重复次数
A 2
B 1

[LittleMan_LC]

select code, Count(distinct con)  from  #test group by code

[surl61240]

楼上简洁 另外一个稍繁琐的（两级group）实现： select aa.code,count(1) as 重复次数 from (select con,code,count(1) cnt from #test group by con,code) as aa group by aa.code

[zestsnake]

select code, count(distinct con)
from  #test
group by code

简单明了，学习了

[卖水果的net]

select code, count(distinct con) from #test group by code

[tiegenZ]

SQL1：
select
code,
COUNT(con)
from(
select distinct con,code from Test
)A
group by code;

SQL2：
select code,count(distinct con)
from test
group by code;

SQL3:
select distinct code, count(*)
from test
group by con, code;

效果图：

[qq_42050768]

select code, count(*) from #test group by con, code

[qq_42050768]

select code, count(*) from #test group by code

[bigemc2]

多谢LS诸位帮忙。