AGGREGATE FUNCTIONS MAX AND MIN IN SQL SERVER

MAX() & 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 

Post a Comment

0 Comments