MySQL GREATEST() Function
Example
Return the greatest value of the list of arguments:
SELECT GREATEST(3, 12, 34, 8, 25);
Try it Yourself »
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("w3Schools.com", "microsoft.com", "apple.com");
Try it Yourself »
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.