当前位置:Gxlcms > mysql > mysqlleast()函数获取最小值

mysqlleast()函数获取最小值

时间:2021-07-01 10:21:17 帮助过:44人阅读

LEAST(N1,N2,N3,N4,......)

LEAST()函数是GREATEST()函数的相反函数。其目的是为了从列表值返回至少值项(N1,N2,N3,等等)。下面的例子显示了LEAST()函数适当的使用和输出:

  1. <code class="language-sql">mysql>SELECT LEAST(3,5,1,8,33,99,34,55,67,43);
  2. +---------------------------------------------------------+
  3. | LEAST(3,5,1,8,33,99,34,55,67,43) |
  4. +---------------------------------------------------------+
  5. | 1 |
  6. +---------------------------------------------------------+
  7. 1 row in set (0.00 sec)</code>

人气教程排行