得到格式化输出

Question

有数据如下图所示

ItemCode SalesPrice PricingLevel 
ITEM-000001 451.000000 Barons 
ITEM-000001 432.000000 Guild 

有没有一种方法可以得到以下的输出：

ItemCode  Barons  Guild 
ITEM-000001 451  432 

Answer 1

SELECT ItemCode, 
Sum(Case when PricingLevel = 'Barons' Then SalesPrice else 0 end) as Barons, 
Sum(Case when PricingLevel = 'Guild' Then SalesPrice else 0 end) as Guild 
FROM myTable 
GROUP BY ItemCode 

Answer 2

刚刚尝试这一点（注：我不知道你的表名，我把它叫做 “项目”）：

SELECT DISTINCT I1.ItemCode, 
     (SELECT SalesPrice FROM Items I2 WHERE I2.ItemCode = I1.ItemCode AND I2.PricingLevel = 'Barons') Barons, 
     (SELECT SalesPrice FROM Items I3 WHERE I3.ItemCode = I1.ItemCode AND I3.PricingLevel = 'Guild') Guild 
FROM Items I1 

，不显示小数零，使用以下命令：

SELECT DISTINCT I1.ItemCode, 
     (SELECT CAST(SalesPrice AS DECIMAL(10,0)) FROM Items I2 WHERE I2.ItemCode = I1.ItemCode AND I2.PricingLevel = 'Barons') Barons, 
     (SELECT CAST(SalesPrice AS DECIMAL(10,0)) FROM Items I3 WHERE I3.ItemCode = I1.ItemCode AND I3.PricingLevel = 'Guild') Guild 
FROM Items I1