列值匹配时的SQL sum字段

SELECt SUM(Value) AS ‘Total’, [Product Name]
FROM TableX
GROUP BY [Product Name]

SQL小提琴示例