MINBY
Finds the minimum of a list of numbers, partitioned by the unique values of a separate column
Last updated
Finds the minimum of a list of numbers, partitioned by the unique values of a separate column
Last updated
MINBY(column
, partition column
)
Returns the minimum value in a column when grouped by unique values within a partition column
MINBY() is a window function, which performs MIN() except partitioned by the unique values of a separate column.
Arguments
Description
column
Column to search for minimum
partition column
Column containing unique values
Outputs the minimum value of a column when grouped by partition column