来自两个或多个领域的最大价值 [英] Biggest value from two or more fields
本文介绍了来自两个或多个领域的最大价值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要从两个领域中获得最大价值:
I need to get the biggest value from two fields:
SELECT MAX(field1), MAX(field2)
现在,我怎么能从这两个中获得最大的价值?
Now, how can I get biggest value from these two?
推荐答案
You may want to use the GREATEST()
function:
SELECT GREATEST(field1, field2);
如果要从所有行中获取绝对最大值,则可能需要使用以下内容:
If you want to get the absolute maximum from all the rows, then you may want to use the following:
SELECT GREATEST(MAX(field1), MAX(field2));
示例1:
SELECT GREATEST(1, 2);
+----------------+
| GREATEST(1, 2) |
+----------------+
| 2 |
+----------------+
1 row in set (0.00 sec)
示例2:
CREATE TABLE a (a int, b int);
INSERT INTO a VALUES (1, 1);
INSERT INTO a VALUES (2, 1);
INSERT INTO a VALUES (3, 1);
INSERT INTO a VALUES (1, 2);
INSERT INTO a VALUES (1, 4);
SELECT GREATEST(MAX(a), MAX(b)) FROM a;
+--------------------------+
| GREATEST(MAX(a), MAX(b)) |
+--------------------------+
| 4 |
+--------------------------+
1 row in set (0.02 sec)
这篇关于来自两个或多个领域的最大价值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文