meta data for this page
  •  

MAX()

Available in: DSQL, PSQL, ESQL

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.