Upsolver SQLake
Contact Support
Search
⌃K
Links
Comment on page

MIN_BY

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

Syntax

MIN_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 minimum SORT value.
If the minimum value is not unique, the first VALUE in the set will be returned.
Previous
MIN
Next
MIN_EACH
Last modified 1yr ago