MAX() Function in sql server

Introduction:

The MAX() function returns the largest value of the selected column.

Sysntax:

SELECT MAX(column_name) FROM table_name;

Example

SELECT MAX(Price) AS HighestPrice FROM table;