MAX_BY

The MAX_BY function returns a value for the <arg> column based on the max value in a separate column, specified by <val>.

If there is more than one max value in <val>, then the first will be used.

Syntax

MAX_BY(<arg>, <val>)

Example

For this example, we will again use the prices table that was created above for the MAX function. The values for that table are below:

In this example below, MAX_BY is used to find the item with the largest price.

SELECT
	MAX_BY(item, price)
FROM
	prices;

Returns: banana