Aggregate Functions MAX and MIN IN SQL Server

MAX() & MIN() IN SQL SERVER

MAX( )

MAX( ) is an aggregate  function that returns the largest (Highest)

value of that column, it takes column name as an argument.

Syntax : 

SELECT Max (column_name) FROM   table_name 

MIN( )

MIN( ) is an aggregate  function that returns the smallest (Lowest)

value of that column, it takes column name as an argument.

Syntax : 

SELECT Min (column_name) FROM   table_name 

Also Read: COUNT Function in SQL Server