从MySQL中的单列获取最高得分值,从两列获取最高得分值
让我们首先创建一个表-
mysql> create table DemoTable790 ( Score1 int, Score2 int );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable790 values(98,76); mysql> insert into DemoTable790 values(78,89); mysql> insert into DemoTable790 values(85,68);
使用select语句显示表中的所有记录-
mysql> select *from DemoTable790;
这将产生以下输出-
+--------+--------+ | Score1 | Score2 | +--------+--------+ | 98 | 76 | | 78 | 89 | | 85 | 68 | +--------+--------+ 3 rows in set (0.00 sec)
该max()
如下:从单个列中获取最大值-
mysql> select max(Score1) from DemoTable790;
这将产生以下输出-
+-------------+ | max(Score1) | +-------------+ | 98 | +-------------+ 1 row in set (0.00 sec)
该greatest()
如下:从两列获取最大值-
mysql> select greatest(Score1,Score2) from DemoTable790;
这将产生以下输出-
+-------------------------+ | greatest(Score1,Score2) | +-------------------------+ | 98 | | 89 | | 85 | +-------------------------+ 3 rows in set (0.03 sec)