Example
Return the greatest value of the list of arguments:
SELECT GREATEST(3, 12, 34, 8, 25);
Definition and Usage
The GREATEST() function returns the greatest value of the list of arguments.
Note: See also the LEAST() function.
Syntax
GREATEST(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 greatest value of the list of arguments:
SELECT GREATEST("iampsp.com", "microsoft.com", "apple.com");