MAX

<< LIST() | FB 2.5 Language Reference | MIN() >>
<< LIST() | FB 2.1 Language Reference | MIN() >>

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.

back to top of page
<< LIST() | FB 2.5 Language Reference | MIN() >>
<< LIST() | FB 2.1 Language Reference | MIN() >>