Book Contents

Book Index

Next Topic

Home

MAX

MAX returns the greatest value of an expression over a group of rows. The return value is the same as the expression data type.

Syntax

MAX ( [ ALL | DISTINCT ] expression )

Semantics

 

ALL | DISTINCT

are meaningless in this context

expression

(any numeric, string, or date/time type) contains at least one column reference