查询，根据sql中的条件将具有相同col值的行合并为具有新col值的行

Question

我有数据在我的表:

700 600200

您可以对每列的case表达式求和:

SELECT   sku,
SUM(CASE grade WHEN 'A' THEN sku END) AS a_price,
SUM(CASE grade WHEN 'B' THEN sku END) AS b_price
FROM     dataTable
GROUP BY sku

您可以通过以下查询来实现:

select p.sku,  p.price as 'A_price', s.B_price
from products p
left join (
select sku, price as 'B_price'
from products
where grade = 'B'
) as s on s.sku = p.sku
where p.grade = 'A';