SUM()函数返回数值列的总和。
SQL SUM() 语法
SELECT SUM(column_name) FROM table_name;
演示数据库
示例
SELECT SUM(count) AS nums FROM access_log;
执行结果
参考:
https://www.yuque.com/docs/share/59501c24-4151-4d2f-a071-a0b3a31307cb
SUM()函数返回数值列的总和。
SQL SUM() 语法
SELECT SUM(column_name) FROM table_name;
演示数据库
示例
SELECT SUM(count) AS nums FROM access_log;
执行结果
参考:
https://www.yuque.com/docs/share/59501c24-4151-4d2f-a071-a0b3a31307cb