萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> MySQL 教學

SQL 彙總函式:SUM() 計算欄位總和

SUM() 回傳數值欄位的總和,忽略 NULL 值。

語法

SELECT SUM(column_name) FROM table_name;

範例資料:Orders 表

+----+------------+------------+----------+
| Id | OrderDate  | OrderPrice | Customer |
+----+------------+------------+----------+
| 1  | 2008/11/12 | 1000       | Hansen   |
| 2  | 2008/10/23 | 1600       | Nilsen   |
| 3  | 2008/09/02 | 700        | Hansen   |
| 4  | 2008/09/03 | 300        | Hansen   |
| 5  | 2008/08/30 | 2000       | Jensen   |
| 6  | 2008/10/04 | 100        | Nilsen   |
+----+------------+------------+----------+

查詢總營收

SELECT SUM(OrderPrice) AS TotalRevenue FROM Orders;

結果

+--------------+
| TotalRevenue |
+--------------+
| 5700         |
+--------------+

分群統計總和

SELECT Customer, SUM(OrderPrice) AS CustomerTotal
FROM Orders
GROUP BY Customer;
+----------+---------------+
| Customer | CustomerTotal |
+----------+---------------+
| Hansen   | 2000          |
| Nilsen   | 1700          |
| Jensen   | 2000          |
+----------+---------------+

注意事項

  • 僅限數值型欄位 (INT, DECIMAL, FLOAT 等)。
  • NULL 值自動忽略,不影響總和。
  • 大數值加總可能溢位,注意資料型態範圍 (如 INT 上限 21 億)。
copyright © 萬盛學電腦網 all rights reserved