Firebird Documentation Index → Firebird 2.5 Language Ref. Update → Aggregate functions → MAX() |
Find a more recent version at Firebird 5.0 Language Reference: MAX()
Available in: DSQL, ESQL, PSQL
Added in: IB
Changed in: 2.1
Description: MAX returns the maximum argument value in the group. If the argument is a string, this is the value that comes last when the active collation is applied.
Result type: Varies
Syntax:
MAX (expression
)
If the group is empty or contains only NULLs, the result is NULL.
Since Firebird 2.1, this function fully supports text BLOBs of any size and character set.
Firebird Documentation Index → Firebird 2.5 Language Ref. Update → Aggregate functions → MAX() |