MAX

The MAX function returns the maximum value in the group.

Syntax

Int8 MAX(x Int8)
Int16 MAX(x Int16)
Int32 MAX(x Int32)
Int64 MAX(x Int64)
UInt8 MAX(x UInt8)
UInt16 MAX(x UInt16)
UInt32 MAX(x UInt32)
UInt64 MAX(x UInt64)
Single MAX(x Single)
Double MAX(x Double)
AnsiString MAX(s AnsiString)
String MAX(s String)
DateTime MAX(x DateTime)
Time MAX(x TimeSpan)

Arguments

• x

  Can be a real number, string, DateTime, or TimeSpan.