least(n1,n2,n3,n4,......)least()函数是greatest()函数的相反函数。其目的是为了从列表值返回至少值项(n1,n2,n3,等等)。下面的例子显示了least()函数适当的使用和输出:
mysql>select least(3,5,1,8,33,99,34,55,67,43);+---------------------------------------------------------+| least(3,5,1,8,33,99,34,55,67,43)                        |+---------------------------------------------------------+| 1                                                       |+---------------------------------------------------------+1 row in set (0.00 sec)
   
 
   