16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

MAX is valid for character data as well as numeric data. When used with a character expression, MAX returns the highest sort order.

Nulls are not included in the result computation. For more information, see Teradata Vantage™ SQL Fundamentals, B035-1141 and Aggregates and Nulls.

If value_expression is a column expression, the column must refer to at least one column in the table from which data is selected.

The value_expression must not specify a column reference to a view column that is derived from a function.