MINBY

Finds the minimum of a list of numbers, partitioned by the unique values of a separate column

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

Output

Outputs the minimum value of a column when grouped by partition column

Example

Last updated