为此,您可以round()与一起使用avg()。让我们首先创建一个表-mysql> create table DemoTable
(
Score int
);
使用插入命令在表中插入一些记录-mysql> insert into DemoTable values(98);
mysql> insert into DemoTable values(97);
mysql> insert into DemoTable values(91);
mysql> insert into DemoTable values(86);
mysql> insert into DemoTable values(45);
使用select语句显示表中的所有记录-mysql> select *from DemoTable;
这将产生以下输出-+-------+
| Score |
+-------+
| 98 |
| 97 |
| 91 |
| 86 |
| 45 |
+-------+
5 rows in set (0.00 sec)
以下是查询以计算列值的平均值并显示不带小数的结果-mysql> select round(avg(Score),0) AS Average from DemoTable;
这将产生以下输出-+---------+
| Average |
+---------+
| 83 |
+---------+
1 row in set (0.00 sec)