MAX Aggregate Function TSQL Tutorial

MAX Example:

CONTRACT_IDAMOUNT
1400
2500
3700

SELECT MAX(c.amount) AS MaxAmount
   FROM contracts c
WHERE c.amount > 300 ;

MaxAmount
700

See also: T-SQL Functions -> Avg -> Count -> Min -> Sum