LEAST(value1,value2,...) returns the smallest (minimum-valued) argument withing two or more arguments : LEAST « Comparison Functions Operators « MySQL Tutorial






  1. MySQL Tutorial
  2. Comparison Functions Operators
  3. LEAST
mysql>
mysql>
mysql>
mysql> SELECT LEAST(2,0);
+------------+
| LEAST(2,0) |
+------------+
|          0 |
+------------+
1 row in set (0.00 sec)








15.11.LEAST
15.11.1.LEAST(value1,value2,...) returns the smallest (minimum-valued) argument withing two or more arguments
15.11.2.LEAST() returns NULL if any argument is NULL
15.11.3.LEAST with float value
15.11.4.Using LEAST with string value
15.11.5.Use LEAST with data in a table