Max « Aggregate Functions « SQL Server / T-SQL Tutorial

9.4.1.MAX returns the largest value in a column of all selected records by the query of any char, number, or datetime datatype.
9.4.2.Finding the smallest and largest selling prices.
9.4.3.A summary query that works on non-numeric columns
9.4.4.Aggregate function, order by desc, group by
9.4.5.The use of the aggregate function MAX in subquery
9.4.6.Finding the Last Row in Employee Using MAX()