如何获得另一列中每个不同值的总和？

你需要

GROUP BY

SUM

SELECt ID,        SUM(price) AS priceFROM YourTableGROUP BY ID