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
Arguments | Description |
| Column to search for minimum |
| Column containing unique values |
Output
Outputs the minimum value of a column when grouped by partition column
Example
Last updated