如何在 MySQL 中對列元素求和？

使用聚合函式 sum() 對 MySQL 中的列元素求和。語法如下 −

select sum(yourColumnName1) as anyVariableName1,sum(yourColumnName2) as anyVariableName2,sum(yourColumnName3) as anyVariableName3,............N from yourTableName;

為了理解以上語法，讓我們建立一個表。以下是建立表的查詢 −

mysql> create table SumDemoOnColumns
   −> (
   −> First int,  
   −> Second int,
   −> Third int
   −> );
Query OK, 0 rows affected (0.56 sec)

使用 insert 命令在表中插入一些資料。查詢如下 −

mysql> insert into SumDemoOnColumns values(10,20,30);
Query OK, 1 row affected (0.18 sec)

mysql> insert into SumDemoOnColumns values(40,50,60);
Query OK, 1 row affected (0.32 sec)

mysql> insert into SumDemoOnColumns values(70,80,90);
Query OK, 1 row affected (0.10 sec)

mysql> insert into SumDemoOnColumns values(100,110,120);
Query OK, 1 row affected (0.16 sec)

使用 select 語句顯示錶中的所有記錄。查詢如下 −

mysql> select *from SumDemoOnColumns;

以下是輸出 −

+-------+--------+-------+
| First | Second | Third |
+-------+--------+-------+
|    10 |     20 |    30 |
|    40 |     50 |    60 |
|    70 |     80 |    90 |
|   100 |    110 |   120 |
+-------+--------+-------+
4 rows in set (0.00 sec)

以下是獲取列總和的查詢 −

mysql> select sum(First) as First,sum(Second) as Second,sum(Third) as Third from SumDemoOnColumns;

以下是輸出 −

+-------+--------+-------+
| First | Second | Third |
+-------+--------+-------+
|   220 |    260 |   300 |
+-------+--------+-------+
1 row in set (0.00 sec)

Anvi Jain

更新於： 2019 年 7 月 30 日

442 次瀏覽

開始您的 職業

完成課程獲取認證

開始