MAX( [ DISTINCT ] expression )

The same data type as the argument.

Rows where expression is NULL are ignored. Returns NULL for a group containing no rows.

For simple comparisons of two expressions, you can also use the GREATER function.

• MIN function [Aggregate]

• Aggregate functions and outer references

The following statement returns the value 138948.000, representing the maximum salary in the Employees table.

SELECT MAX( Salary )
FROM Employees;