The aggregate function MAX () is used to find the maximum value of the selected column in SQL. The following is the syntax to find max value in the selected column:
The following statement returns the top salary of the employee table:
SELECT MAX(Salary) as Maximum_Salary
If you want to learn MAX () and other aggregate functions with complex queries, you can check out this SQL tutorial.