Example: CHARACTER Data
The following SELECT returns the immediately following result.
SELECT MAX(Name) FROM Employee; 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
For time series examples, see Teradata Vantage™ - Time Series Tables and Operations, B035-1208.