MIN

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

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

1min(<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 smallest value.

Get the lowest price.

1SELECT min(price) AS lowest_price
2FROM products;

Find the minimum value per group.

1SELECT category, min(price) AS min_price
2FROM products
3GROUP BY category;

Find the earliest date.

1SELECT min(order_date) AS first_order
2FROM orders;

• MAX
• MIN_BY
• Aggregate Functions