目录

MySQL LEAST() Function

❮ MySQL Functions

Example

Return the smallest value of the list of arguments:

SELECT LEAST(3, 12, 34, 8, 25);
Try it Yourself »

Definition and Usage

The LEAST() function returns the smallest value of the list of arguments.

Note: See also the GREATEST() function.

Syntax

LEAST( arg1, arg2, arg3, ...)

Parameter Values

Parameter Description
arg1, arg2, arg3, ... Required. The list of arguments to be evaluated

Technical Details

Works in: From MySQL 4.0

More Examples

Example

Return the smallest value of the list of arguments:

SELECT LEAST("w3Schools.com", "microsoft.com", "apple.com");
Try it Yourself »

❮ MySQL Functions