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)