MySQL least function

LEAST (N1,n2,n3,n4,......)

The LEAST () function is the inverse function of greatest (). The purpose is to return the item minimum value from the list of values (N1,N2,N3, and so on). The following example shows the correct use and output of the least () function: ()

Sql>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)

Greatest

The maximum number of fields to take in a record:

select greatest(x,y,z)         #最少两个参数fromtable_1group by a

Least

The minimum value for a record to take several fields:

select least(x,y,z)  #最少2个参数from table_1...

MySQL least function