Link Search Menu Expand Document

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>)
Parameter Description
<arg> The column from which the value is returned.
<val> The column that is search for a maximum value.

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:

item price
apple 4
banana 25
orange 11
kiwi 20

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