Returns the maximum value in the expression. May be followed by the OVER clause.
The following example returns the highest (maximum) tax rate.
USE AdventureWorks2008R2; GO SELECT MAX(TaxRate) FROM Sales.SalesTaxRate; GO
Here is the result set.
(1 row(s) affected)
Warning, null value eliminated from aggregate.