MIN

All functions > AGGREGATE > MIN

Returns the minimum value in the group.

Syntax

MIN(expr: T) → T
sql

Type Parameters:

  • T: Any comparable type (numeric, string, date, timestamp, boolean)

Arguments

ParameterTypeRequiredDescription
exprTYesThe expression to find the minimum value of
num_valuesANYNoOptional number of minimum values to return as array

Returns

The minimum value, or array of bottom N values if num_values specified

Notes

  • Returns the smallest value in the group
  • Works with numeric, string, and date types
  • NULL values are excluded from the calculation
  • Returns NULL if all values are NULL or group is empty
  • With num_values parameter, returns an array of the N smallest values
  • Can be used with WHERE clause to filter before aggregation
  • Can be used with GROUP BY clause for grouped aggregation
Suggest changes to this page
Last update at: 2025/10/13 10:23:46