MAX

Returns the largest of the given numbers.

Usage examples 

  • MAX(-5, 0.1, 2 + 6)

  • MAX(tableA.fieldB, 1, '88')

Syntax 

MAX ( number1, [ number2, ... ] )

  • number1 - Any numeric expression.

  • number2 - Any numeric expression.

Returns 

number - The maximum value.

Functions reference