MAXIMUM Function Examples | Teradata Vantage - Examples: Using the MAXIMUM Function - Analytics Database - Teradata Vantage

Example: CHARACTER Data

The following SELECT returns the immediately following result.

SELECT MAX(Name) 
FROM Employee; 

Result:

Maximum(Name)
-------------
Zorn J

Example: Column Expressions

You want to know which item in your warehouse stock has the maximum cost of sales.

SELECT MAX(CostOfSales) AS m, ProdID 
FROM Inventory
GROUP BY ProdID
ORDER BY m DESC;
   
Maximum(CostOfSales)  ProdID
--------------------  ------
                1295    3815
                 975    4400
                 950    4120