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

MIN()

Tip

Find a more recent version at Firebird 5.0 Language Reference: MIN()

Available in: DSQL, ESQL, PSQL

Added in: IB

Changed in: 2.1

Description: MIN returns the minimum argument value in the group. If the argument is a string, this is the value that comes first when the active collation is applied.

Result type: Varies

Syntax: 

MIN (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: MAX()Firebird Documentation IndexUp: Aggregate functionsNext: Internal functions
Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateAggregate functions → MIN()