34,838
社区成员




with list as(
select top 10 商品名称,金额=sum(金额)
from datatable
GROUP BY 商品名称
order by sum(金额) desc
)
select 商品名称,金额,业务员=(select top 10 业务员+',' from datatable b where a.商品名称=b.商品名称 group by 商品名称, 金额 order by sum(金额) desc for xml path(''))
from list a
;
with list as(
select top 10 商品名称,金额=sum(金额)
from datatable
order by sum(金额) desc
)
select 商品名称,金额,业务员=(select top 10 业务员+',' from datatable b where a.商品名称=b.商品名称 group by 金额 order by sum(金额) desc for xml path(''))
from list a