11.7.4 SUM(字段名称)函数
SUM(字段名称)函数返回数据表中某列数据的求和结果。使用示例如下:
mysql> SELECT SUM(age) FROM employee;
+----------+
| SUM(age) |
+----------+
| 111 |
+----------+
1 row in set (0.00 sec)
SUM(字段名称)函数返回数据表中某列数据的求和结果。使用示例如下:
mysql> SELECT SUM(age) FROM employee;
+----------+
| SUM(age) |
+----------+
| 111 |
+----------+
1 row in set (0.00 sec)