select 序号= min(ID),
业务员= con_seller,
[药A]= case when sum(case when con_M_name='药A' then con_amount else 0 end) <>0 then cast((sum(case when con_M_name='药A' then con_amount else 0 end)) as varchar(20)) else '-' end ,
[药B]=case when sum(case when con_M_name='药B' then con_amount else 0 end)<>0 then cast((sum(case when con_M_name='药B' then con_amount else 0 end)) as varchar(20)) else '-' end
from m_con_B group by con_seller order by 序号
业务员= con_seller,
[药A]= case when sum(case when con_M_name='药A' then con_amount else 0 end) <>0 then cast((sum(case when con_M_name='药A' then con_amount else 0 end)) as varchar(20)) else '-' end ,
[药B]=case when sum(case when con_M_name='药B' then con_amount else 0 end)<>0 then cast((sum(case when con_M_name='药B' then con_amount else 0 end)) as varchar(20)) else '-' end
from m_con_B group by con_seller order by 序号
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货