This function is used to get the maximum value from the selected field .
Syntax :

select max ( column_name ) from table_name ;

Example :
Table name : Employee_Info

  Id        Employee_name          Employee_Age               Employee _Salary
  1            Mukesh                  23                           120000
  2            Ayush                   24                           200000
  3            Ishan                   20                           400000
  4            Pranav                  35                           123,00000
  5            Abhishek                26                           800000
  6            Ravi                    25                           300000
  7            David                   40                           8000

Query to select maximum salary from a table :

select max ( Employee_Salary ) as Highest_Salary from Employee_Info ;

Output :

Highest_Salary
123,00000