SELECT SUM(expression)
FROM tables
WHERE predicates;
expression 可以是數值欄位、算術運算式或函數回傳值。
-- 計算薪資超過 25,000 的員工總薪資
SELECT SUM(salary) AS "Total Salary"
FROM employees
WHERE salary > 25000;
SELECT SUM(DISTINCT salary) AS "Total Salary"
FROM employees
WHERE salary > 25000;
僅對不重複的薪資值求和。
SELECT SUM(income - expenses) AS "Net Income"
FROM gl_transactions;
SELECT SUM(sales * 0.10) AS "Commission"
FROM order_details;
SELECT department, SUM(sales) AS "Total sales"
FROM order_details
GROUP BY department;
依部門彙總銷售額,常用於報表產出。
SUM 的欄位建立索引,可加速聚合運算。SUM 運算式中使用複雜函數,以免阻礙索引使用。