MIN Aggregate Function TSQL Tutorial

MIN Example:

CONTRACT_IDAMOUNT
1400
2500
3700

SELECT MIN(c.amount) AS MinAmount
   FROM contracts c
WHERE c.amount > 300 ;

MinAmount
400

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