MAX

The MAX function returns the maximum value of all numbers in the set (e.g., Salary Paid).

Syntax

SELECT MAX(…)
SELECT MAX(fact)

Examples

The MAX of the Store Sales fact is the highest sales transaction value on record:

SELECT MAX(Sales)
SELECT AVG(metric that uses fact)