Given two or more parameters, the
max() function returns
the parameter with the largest value. If any parameter is a
NULL, a NULL will be returned. Otherwise, BLOB values are
considered to have the largest value, followed by text values.
These are followed by the numeric types (mixed integer values
and floating-point values), sorted together in their natural
order.
If you want the comparison to use a specific collation, use a
COLLATE expression to
attach an explicit collation to the input values. For example,
max(
.param1 COLLATE NOCASE,
param2
)
There is also an aggregate version of max() that takes a single parameter.