Reference Guide
>
TDV Support for SQL Functions
>
TDV-Supported Analytical Functions
>
MAX
MAX
MAX returns the maximum value of an expression.
Syntax
MAX ( [DISTINCT | ALL ] expression) OVER (window_clause)
Remarks
•
Without a window clause, MAX is a simple aggregate function. (See
MAX
.)
•
The expression can be any orderable data type.