GREATEST(value1,value2,...)

With two or more arguments, returns the largest (maximum-valued) argument. The arguments are compared using the same rules as for LEAST().

Syntax

MYSQL Copy

SELECT GREATEST(2,0);
2
SELECT GREATEST(34.0,3.0,5.0,767.0);
767.0
SELECT GREATEST('B','A','C');
'C'

Examples

Example

GREATEST() returns NULL if any argument is NULL.

MYSQL Copy

SELECT GREATEST(2,0);
2
SELECT GREATEST(34.0,3.0,5.0,767.0);
767.0
SELECT GREATEST('B','A','C');
'C'