least
Description
Returns the smallest value from a list of one or more parameters.
Generally, the return value has the same data type as the input.
The comparison rules are the same as the greatest function.
Syntax
LEAST(expr1,...);
Parameters
expr1
: the expression to compare. It supports the following data types:
-
SMALLINT
-
TINYINT
-
INT
-
BIGINT
-
LARGEINT
-
FLOAT
-
DOUBLE
-
DECIMALV2
-
DECIMAL32
-
DECIMAL64
-
DECIMAL128
-
DATETIME
-
VARCHAR
Examples
Example 1: Return the smallest value for a single input.
select least(3);
+----------+
| least(3) |
+----------+
| 3 |
+----------+
1 row in set (0.00 sec)
Example 2: Return the smallest value from a list of values.
select least(3,4,5,5,6);
+----------------------+
| least(3, 4, 5, 5, 6) |
+----------------------+
| 3 |
+----------------------+
1 row in set (0.01 sec)
Example 3: One parameter is of the DOUBLE type and a DOUBLE value is returned.
select least(4,4.5,5.5);
+--------------------+
| least(4, 4.5, 5.5) |
+--------------------+
| 4.0 |
+--------------------+
Example 4: The input parameters are a mix of number and string but the string can be converted into a number. The parameters are compared as numbers.
select least(7,'5');
+---------------+
| least(7, '5') |
+---------------+
| 5 |
+---------------+
1 row in set (0.01 sec)
Example 5: The input parameters are a mix of number and string but the string cannot be converted into a number. The parameters are compared as strings. The string '1'
is less than 'at'
.
select least(1,'at');
+----------------+
| least(1, 'at') |
+----------------+
| 1 |
+----------------+
Example 6: The input parameters are characters.
mysql> select least('A','B','Z');
+----------------------+
| least('A', 'B', 'Z') |
+----------------------+
| A |
+----------------------+
1 row in set (0.00 sec)
Keywords
LEAST, least