我尝试过但失败了:
mysql> select max(1,0);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right syntax to use
near '0)' at line 1
Use 最伟大的() http://dev.mysql.com/doc/refman/5.6/en/comparison-operators.html#function_greatest
E.g.:
SELECT GREATEST(2,1);
注意:每当任何单个值包含 null 时,该函数总是返回 null (感谢用户@sanghavi7)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)