TD_WhichMax Function | WhichMax | Teradata Vantage - TD_WhichMax - Analytics Database

Database Analytic Functions

Analytics Database
Release Number
June 2022
English (United States)
Last Update
Product Category
Teradata Vantageā„¢

TD_WhichMax displays all rows that have the maximum value in a specified input table column. The maximum value represents the upper limit of a quantity or set of values. For example, if we have a set of numbers such as {3, 5, 1, 7, 2}, the maximum value would be 7 since it is the largest number in the set.

Finding maximum values in a dataset is important for the following reasons:
  • Identification of outliers: The maximum values in a dataset may indicate the presence of outliers, which are data points that are significantly different from the rest of the data. Outliers can skew statistical analyses and make it difficult to draw meaningful conclusions from the data. Identifying these outliers can help researchers to decide whether to remove them from the dataset or take other corrective actions.
  • Understanding the range of values: Knowing the maximum value in a dataset can help researchers to understand the range of values that are present in the data. This can be useful for determining the accuracy and precision of measurements, identifying potential errors or biases in the data collection process, and determining the sensitivity of statistical analyses to small changes in the data.
  • Establishing performance benchmarks: In certain contexts, such as sports or financial markets, the maximum values can be used to establish performance benchmarks. For example, the fastest time in a race or the highest stock price can serve as a benchmark for future performance. This can help individuals and organizations to set goals and measure their progress towards achieving them.
  • Safety considerations: In some cases, the maximum values of certain parameters can be used to establish safety standards. For example, in engineering, the maximum load that a bridge can support or the maximum wind speed that a building can withstand can be used to establish safety guidelines and ensure that structures are built to withstand expected conditions.

Finding maximum values in a dataset can help researchers to better understand the data, identify potential issues, and establish benchmarks and safety standards in a variety of contexts.