请教一个查询统计排序问题

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