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, 274🔥, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...