LEAST()함수

 

LEAST(value1, value2,....)

With two or more arguments, returns the smallest(minimum-valued) argument. The argements are compared using the following rules:

 

인자로 있는 값 들중에서 가장 작은 값을 return 한다. 

 

여태 처음본다. ^^;;

 

mysql> SELECT LEAST(2, 0) ;
+-------------+
| LEAST(2, 0) |
+-------------+
|           0 |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT LEAST('B', 'A', 'C') ;
+----------------------+
| LEAST('B', 'A', 'C') |
+----------------------+
| A                    |
+----------------------+
1 row in set (0.00 sec)

 

mysql>  SELECT LEAST(NULL, 'A', 'C') ;
+-----------------------+
| LEAST(NULL, 'A', 'C') |
+-----------------------+
| NULL                  |
+-----------------------+
1 row in set (0.00 sec)

mysql>  SELECT LEAST(NULL, 0) ;
+----------------+
| LEAST(NULL, 0) |
+----------------+
|           NULL |
+----------------+
1 row in set (0.00 sec)