62,615
社区成员
发帖
与我相关
我的任务
分享
mysql> select * from t;
+----+---------+-------+
| id | name | value |
+----+---------+-------+
| 1 | Math | 92 |
| 2 | History | 45 |
| 3 | Scient | 99 |
+----+---------+-------+
3 rows in set (0.00 sec)
mysql> select sum(value),avg(value) from t;
+------------+------------+
| sum(value) | avg(value) |
+------------+------------+
| 236 | 78.6667 |
+------------+------------+
1 row in set (0.00 sec)