Upsolver SQLake
Contact Support
Search
⌃K
Links
Comment on page

MAX_BY

Gets the value that corresponds to the maximum value of a different field in the time window.

Syntax

MAX_BY(VALUE, SORT)‌

Arguments

VALUE

Type: any
The field to return.

SORT

Type: numeric
The field to sort by.

Returns

Type: any
Returns the VALUE that corresponds to the maximum SORT value.
If the maximum value is not unique, the first VALUE in the set will be returned.
Previous
MAX
Next
MAX_EACH
Last modified 1yr ago