从MySQL表格的整个四列中找到最低分
要从全部四列中找到最低分，请使用MySQLLEAST()函数。让我们首先创建一个表-
create table DemoTable( Score1 int, Score2 int, Score3 int, Score4 int );
使用插入命令在表中插入一些记录-
insert into DemoTable values(88,76,45,56); insert into DemoTable values(99,78,87,34); insert into DemoTable values(34,32,56,98);
使用select语句＆minsu;显示表中的所有记录。
select *from DemoTable;
这将产生以下输出-
+--------+--------+--------+--------+ | Score1 | Score2 | Score3 | Score4 | +--------+--------+--------+--------+ | 88 | 76 | 45 | 56 | | 99 | 78 | 87 | 34 | | 34 | 32 | 56 | 98 | +--------+--------+--------+--------+ 3 rows in set (0.00 sec)
以下是从数据库的四列中查找最低分数的查询-
select least(Score1,Score2,Score3,Score4) AS MinimumScore from DemoTable;
这将产生以下输出-
+--------------+ | MinimumScore | +--------------+ | 45 | | 34 | | 32 | +--------------+ 3 rows in set (0.00 sec)