sql - 汇总汇总数据

Question

我有一个如下表:

SoftwareName    Count    CountryProject         15       CanadaVisio           12       CanadaProject         10       USAVisio           5        USA

我如何查询它来给我一个总结，比如......

SoftwareName    Canada    USA    TotalProject         15        10     25Visio           12        5      17

如何在 T-SQL 中执行操作？

Answer 1

SELECT SoftwareName, 
  SUM( CASE Country WHEN 'Canada' THEN [Count] ELSE 0 END ) AS Canada,
  SUM( CASE Country WHEN 'USA'    THEN [Count] ELSE 0 END ) AS USA,
  SUM( [Count] ) AS Total
FROM [Table] 
GROUP BY SoftwareName;