MIN
Returns the minimum value among the non-NULL input expressions.
Syntax
MIN(expression any primitive) → same as input
- expression: Input expression.
Examples
Aggregate function exampleSELECT MIN("total_amount")
FROM "Samples"."samples.dremio.com"."NYC-taxi-trips"
-- EXPR$0
-- -1430.0
MIN(expression any primitive) → same as input
- expression: Input expression.
Examples
Window function exampleSELECT "trip_distance_mi",
MIN("total_amount") OVER(PARTITION BY "trip_distance_mi") "min_total_amount"
FROM "Samples"."samples.dremio.com"."NYC-taxi-trips"
LIMIT 1
-- trip_distance_mi, min_total_amount
-- 0.06, -52.5
Usage Notes
For information about the data types that are supported in Dremio, see Data Types.
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.