MIN_BY
The MIN_BY function returns the value of arg column at the row in which the val column is minimal.
If there is more than one minimal values in val, then the first will be used.
Syntax
MIN_BY(arg, val)
| Parameter | Description |
|---|---|
<arg> | The column from which the value is returned. |
<val> | The column that is search for a minimum value. |
Example
For this example, we will again use the prices table that was created above for the MIN function. The values for that table are below:
| item | price |
|---|---|
| apple | 4 |
| banana | 25 |
| orange | 11 |
| kiwi | 20 |
In this example below, MIN_BY is used to find the item with the lowest price.
SELECT
MIN_BY(item, price)
FROM
prices
Returns: apple