MAX

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the maximum value of an expression across all input values.

1max(<expression>)

• <expression>: An expression of any comparable type.

Returns the same type as the argument. Returns NULL if no rows are selected.

• NULL values are ignored in the calculation.
• Works with numeric types, strings, dates, and other comparable types.
• For strings, returns the lexicographically greatest value.

Get the highest price.

1SELECT max(price) AS highest_price
2FROM products;

Find the maximum value per group.

1SELECT category, max(price) AS max_price
2FROM products
3GROUP BY category;

Find the most recent date.

1SELECT max(order_date) AS latest_order
2FROM orders;

• MIN
• MAX_BY
• Aggregate Functions