Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateAggregate functions → MAX()
Firebird Home Firebird Home Prev: LIST()Firebird Documentation IndexUp: Aggregate functionsNext: MIN()

MAX()

Tip

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.

Prev: LIST()Firebird Documentation IndexUp: Aggregate functionsNext: MIN()
Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateAggregate functions → MAX()