On this page

    Categories: Aggregate, Window

    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 example
    SELECT 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 example
    SELECT "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.