目录

MySQL GREATEST() Function

❮ MySQL Functions

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 »

❮ MySQL Functions