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.