SQL Tutorial SQL Advanced SQL Database SQL References

MySQL GREATEST() Function



The MySQL GREATEST() function returns the largest value in a list of expressions. In special cases it returns the following:

  • If any of the expression in the list is NULL, then NULL is returned.

Syntax

GREATEST(expr1, expr2, ... expr_n)

Parameters

expr1, expr2, ... expr_n Required. Specify the list of expressions to be evaluated.

Return Value

Returns the largest value in a list of expressions.

Example 1:

The example below shows the usage of GREATEST() function.

mysql> SELECT GREATEST(20, 30, 60, 10);
Result: 60

mysql> SELECT GREATEST('20', '30', '60', '10');
Result: '60'

mysql> SELECT GREATEST('D', 'G', 'X', 'A');
Result: 'X'

mysql> SELECT GREATEST('Alpha', 'Beta', 'Delta', 'Gamma');
Result: 'Gamma'

mysql> SELECT GREATEST('Alpha1', 'Alpha2', 'Alpha3', 'Alpha4');
Result: 'Alpha4'

mysql> SELECT GREATEST(20, 30, 60, 10, NULL);
Result: NULL

Example 2:

Consider a database table called Sample with the following records:

Dataxyz
Data 110011
Data 2201512
Data 3303013
Data 4404514
Data 5506015

To get the largest value, when values of column x, column y and column z are compared, the following query can be used:

SELECT *, GREATEST(x, y, z) AS GREATEST_Value FROM Sample;

This will produce the result as shown below:

DataxyzGREATEST_Value
Data 11001111
Data 220151220
Data 330301330
Data 440451445
Data 550601560

❮ MySQL Functions

5