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({fact/sales})
The MAX function returns the maximum value of all numbers in the set (e.g., Salary Paid).
SELECT MAX(…)
SELECT MAX(fact)
The MAX of the Store Sales fact is the highest sales transaction value on record:
SELECT MAX({fact/sales})