max_n_by()

Track the largest values and associated data in a set of values

Since 1.16.0

Construct an aggregate that keeps track of the largest values passed through it, as well as some associated data which is passed alongside the value.

Arguments

Name	Type	Default	Required	Description
value	BIGINT | DOUBLE PRECISION | TIMESTAMPTZ	-	✔	The values passed into the aggregate
data	ANYELEMENT	-	✔	The data associated with a particular value
capacity	BIGINT	-	✔	The number of values to retain.

Returns

The compiled aggregate. Note that the exact type will be MaxByInts, MaxByFloats, or MaxByTimes depending on the input type