sql范例:select Email,count(Guid)as TotalOrderCount,sum(case when PromotionType=8 then 1 else 0 end)as OriginalCount,sum( SaleTotalPrice )as SumTotalPrice,sum(case when PromotionType=8 then SaleTotalPrice else 0 end)as SumOriginalPriceinto #t from #torde