LEAST with float value : LEAST « Comparison Functions Operators « MySQL Tutorial






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

mysql>








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