LARGEST
Returns the largest value from the supplied values. Any number of values to compare can be supplied.
While all datatypes can be evaluated by the function, evaluation will only take place when compatible datatypes are supplied.
The table below shows the mix of datatypes that may be successfully compared.
Datatype1 | Datatype2 |
---|---|
Decimal | Integer |
Decimal | Currency |
Geographic | String |
LARGEST(<Ignore Nulls>, <Value1> [, <Value2>] [, <ValueN> ]...)
-
Ignore Nulls: True/False value to determine whether or not to ignore null values. If Nulls are not ignored and there is a null value then the result will be NULL.
-
Value1 to N: The values to compare to determine the largest value. Values can be actual values, fields, or expressions