sql-server-2005 - 使用 Sql 查询从行到列

Question

嗨，我有一个表格，其中的列为

              Cost     Rate

              Repair   12
              Repair   223
              Wear     1000    
              Wear     666
              Fuel     500
              Repair   600
              Fuel     450
              Wear     400

现在我想要这个数据

             Repair    Wear   Fuel
               825     2066    950

使用Sql查询

提前致谢

Answer 1

select sum(case when cost = 'Repair' then rate else null end) as Repair
, sum(case when cost = 'Wear' then rate else null end) as Wear
, sum(case when cost = 'Fuel' then rate else null end) as Fuel 
from CostRateTable