Collections:
LEAST() - Finding the Least/Minimum Value
How to find the least (minimum) value of a given list of values using the LEAST() function?
✍: FYIcenter.com
LEAST(val1, val2, ...) is a MySQL built-in function that returns the least (minimum) value of a given list of values. For example:
SELECT LEAST(70, 89, 73, 99, 101, 110, 116, 101, 114); -- +------------------------------------------------+ -- | LEAST(70, 89, 73, 99, 101, 110, 116, 101, 114) | -- +------------------------------------------------+ -- | 70 | -- +------------------------------------------------+ SELECT LEAST('Grape', 'Orange', 'Banana', 'Apple'); -- +---------------------------------------------+ -- | LEAST('Grape', 'Orange', 'Banana', 'Apple') | -- +---------------------------------------------+ -- | Apple | -- +---------------------------------------------+
If the arguments comprise a mix of multiple data types, LEAST() converts them to the same data type using the following rules:
Here are examples with arguments of mix data types:
SELECT LEAST(70, 89, 73, 99, 101, 'Banana', 'Apple'); -- +-----------------------------------------------+ -- | LEAST(70, 89, 73, 99, 101, 'Banana', 'Apple') | -- +-----------------------------------------------+ -- | 101 | -- +-----------------------------------------------+ SELECT LEAST(TRUE, 70, 89, NULL, 'Banana', 'Apple'); -- +----------------------------------------------+ -- | LEAST(TRUE, 70, 89, NULL, 'Banana', 'Apple') | -- +----------------------------------------------+ -- | NULL | -- +----------------------------------------------+ SELECT LEAST(NOW(), 'Yesterday'), LEAST('2023-12-16', 'Yesterday'); -- +---------------------------+----------------------------------+ -- | LEAST(NOW(), 'Yesterday') | LEAST('2023-12-16', 'Yesterday') | -- +---------------------------+----------------------------------+ -- | 2023-12-16 20:35:34 | 2023-12-16 | -- +---------------------------+----------------------------------+ SELECT LEAST(NOW(), '2099-12-01', CURRENT_TIMESTAMP()); -- +-------------------------------------------------+ -- | LEAST(NOW(), '2099-12-01', CURRENT_TIMESTAMP()) | -- +-------------------------------------------------+ -- | 2023-12-16 20:36:43 | -- +-------------------------------------------------+ SELECT LEAST(JSON_ARRAY(70, 89), JSON_ARRAY('70', '89')); -- +---------------------------------------------------+ -- | LEAST(JSON_ARRAY(70, 89), JSON_ARRAY('70', '89')) | -- +---------------------------------------------------+ -- | ["70", "89"] | -- +---------------------------------------------------+
Reference information of the LEAST() function:
LEAST(val1, val2, ...): min Returns the least (minimum) value of a given list of values. Arguments, return value and availability: val1, val2, ...: Two or more values to be examined. min: Return value. The minimum value of multiple values. Available since MySQL 4.0.
Related MySQL functions:
⇒ NAME_CONST() - PS Thread ID of Given Connect
⇐ ISNULL() - Detecting NULL Value
2023-12-19, 286🔥, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...