SQL MAX function Description The SQL MAX function is used to return the maximum value of an expression in a SELECT statement. Syntax The syntax for the SQL MAX function is: SELECT MAX( expression ) FROM tables WHERE conditions; Parameters or Arguments expression can be a numeric field or formula. Example - With Single expression The simplest way to use the SQL MAX function would be to return a single field that calculates the MAX value. For example, you might wish to know the maximum salary of all employees. SELECT MAX(salary) AS "Highest salary" FROM employees; In this SQL MAX function example, weve aliased the MAX(salary) field as "Highest salary". As a result, "Highest salary" will display as the field name when the result set is returned. Example - Using SQL GROUP BY Clause In some cases, you will be required to use the SQL GROUP BY clause with the SQL MAX function. For example, you could also use the SQL MAX function to return the name of ea...