Max
Aggregation
Max(column)
SQL MAX over the current context; works on numbers, dates and strings. Blank over zero rows.
When to use it
Section titled “When to use it”- Most recent activity (
Max(Sales.OrderDate)for last order date per group), price ceilings, latest readings.
Example
Section titled “Example”LastOrderDate := Max(Sales.OrderDate)