MEDIAN Function | VantageCloud Lake - MEDIAN - Teradata Vantage

For numeric values, returns the middle value or an interpolated value that is the middle value after the values are sorted. Nulls are ignored in the calculation.

The function returns the same data type as the data type of the argument.

• MEDIAN Function Syntax
• Example: MEDIAN Function

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Type

MEDIAN is an aggregate function.