max function with where clause in sql server

SQL Server MAX()  function is an aggregate function that is used to find the Maximum or Largest value of a column .