Explain MAX function in SQL Server.

The MAX function is used to find the highest value in a particular column.

Ex :

Select max(EmployeeAge)as MaximumAgedEmployee from Employees

This Query will display the highest age of the employee from “EmployeeAge” column, the output will be displayed with the column name “MaximumAged Employee”.