您需要GROUP BY
您的客户ID:
SELECT CustomerID, SUM(PurchasePrice) AS PurchaseTotal
FROM sales
GROUP BY CustomerID;
MYSQL-基于其他列中的公共值的列的SUM
您需要GROUP BY
您的客户ID:
SELECT CustomerID, SUM(PurchasePrice) AS PurchaseTotal
FROM sales
GROUP BY CustomerID;